Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “mortisers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mortisers118616(None) 
mortiser1078471mortiser_
mortises10713611mortise_s
amortises1178822amortise_s
morrises10711072morrise_s
mortices12711562mortice_s
mortifiers1544392mortifiers
mortise9713532mortise__
mortised1178742mortise_d
poetisers1145302poetisers
amortise10428513amortise__
amortised1285813amortise_d
amortizes2087283amortize_s
bruisers10307953_bruisers
cortices12615013cortice_s
cortisols1144783cortisols
cottiers10399153cotti_ers
courtiers1146693courti_ers
cruisers10438273_cruisers
dorsers83516303dor__sers
exorcisers1942553exorcisers
forgivers1643713forgivers
forties104323863forti_e_s
fortifiers1644533fortifiers
lorimers1036613lor_imers
loriners839963lor_iners
lorises73918593lor_ise_s
mantises10317923mantise_s
mariners103113863mar_iners
marriers103312473marri_ers
martinets1138883martinets
merises93421423mer_ise_s
metiers93312843m_eti_ers
misers85025703m___isers
mitises9315543m_itise_s
moilers93615203mo__ilers
molters93816973molt__ers
momsers113810843mo__msers
monetises11311043monetise_s
monikers1437413mo_nikers
mooters93818623moot__ers
moraines10314363moraine_s
moralises11314003moralise_s
moralizers2145843moralizers
morasses1038903morasse_s
morsels94112653mor__sels
mortars93411523mort__ars
mortgagers1442233mortgagers
mortice11711493mortice__
morticed1377163mortice_d
mortifier1446923mortifier_
mortifies1439393mortifies
mortising1238693mortising
mossers94116193mo__ssers
mothers123717623mo_t_hers
motiles93317433mo_tile_s
motioners1146573mo_tioners
motives123611893mo_tive_s
mottlers10388183mo_ttlers
mousers95216443mo__users
mouthers133811303mout_hers
murthers1336543murt_hers
northers1139333nort_hers
noticers1035693no_ticers
orbiters1036593_orbiters
orrises71312233_orrise_s
partiers103514243parti_ers
poetiser1037313poetiser_
poetises10313953poetise_s
poetizers2045103poetizers
poisers94214433po__isers
porters93722703port__ers
portiere1038773porti_ere
portieres1138213porti_eres
portioners1257413portioners
praisers103410833_praisers
promisers13268203promisers
raisers73617393__raisers
risers64624783__r_isers
rotifers1136043ro_tifers
sorters74221133sort__ers
sorties74126403sorti_e_s
surmisers1145203surmisers
tortoises947183tortoise_s
torturers944343torturers
unmortises1244263unmortise_s
upraisers11174423upraisers
uprisers10206773upr_isers
vortices1369123vortice_s
worriers11257813worri_ers

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.420425454.8
2DLD Change Limit148641906.70322175.3
3Display Results90900.0461956.5
 (SQL Overall)178691907.16924925.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.