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 “migrator” 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.

77 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
migrator114787(None) 
migrators1247541migrators
migratory1545341migratory
migrate101314172migrat_e
migrated121110512migrated
migrates111112852migrates
migration12179702migration
mirador1046502mi_rador
nitrator849552nitrator
titrator858542titrator
vibrator13227342vibrator
aerator7314843_aerator
agitator946713agitator
avigator12236773avig_ator
barrator1048403barrator
citator9310123ci_tator
curator9312213_curator
denigrator1245223denigrator
dictator1147263dictator
digestor10246553digestor
dilator82712783di_lator
emigrate1149603emigrat_e
emigrated1347073emigrated
emigrates1248583emigrates
emigration13228213emigration
figeater1236953figeater
fumigator1543923fumig_ator
gator64416033__g_ator
gigaton946343gig_aton
grantor84010933__grantor
grater74625443__grater
gyrator1135713_gyrator
hydrator1545763hydrator
ignitor8125263_ignitor
imitator1047113imitator
imperator1347783imperator
irater65218353_i_rater
legator83011133leg_ator
liberator1147063liberator
libratory14255803libratory
literator948683literator
macerator13217633macerator
mandator1148183mandator
mediator1139043mediator
megaton10269853meg_aton
meliorator12105223meliorator
migraine1157863migraine
migrant10314313migra_nt
migrants1138183migrants
migrating13910533migrating
migrations13168683migrations
minatory1338553mi_natory
miradors1146853mi_radors
mirror848003mi_r_ror
mislabor1244503mislabor
misrate91319143misrat_e
misrated111315383misrated
misrates101318243misrates
mistutor1044943mistutor
mitigator1245413mitigator
moderator12106543moderator
moratory1347823m_oratory
narrator847563narrator
negator83010673neg_ator
nitrators949213nitrators
operator10310093operator
orator6314533__orator
piscator1246923piscator
signatory1344623signatory
titrators948383titrators
viator93211833vi__ator
vibrato12247383vibrato_
vibrators14237253vibrators
vibratory17235563vibratory
vibratos13217483vibratos
violator1146283violator
vitiator1147043vitiator

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 Filter1786911461620.420425454.8
2DLD Change Limit146162776.65621959.4
3Display Results77770.0332333.3
 (SQL Overall)178691777.10925135.9
 
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.