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

95 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
minivan124571(None) 
minivans1345411minivans
minibar11106132minibar
minicab13177172minicab
minicam131110062minicam
minicar11109322minicar
minikin13258982minikin
minilab11126002minilab
minima105512652minima_
minimal114010602minimal
minimax18376012minimax
minion83416242mini_on
miniver1238392miniver
minyan1138172min_yan
banian8315383bani_an
divan96114843__divan
eonian6311833eoni_an
finial92814183fini_al
finical1239703finical
finikin14266863finikin
gingiva1253293gingiva_
gingivae1352173gingivae
gingival1342943gingival
hominian1357093homini_an
indican1048243_indican
inia45024703_ini_a_
inion54620183_ini_on
inspan837513_inspan
invar839513_in_var
kinin94917333kini__n
kinsman1335963kinsman
lineman939123lineman
linin58025523lini__n
linkman1335393linkman
magian9312833magi_an
mania75634153mani_a_
maniac103917973mani_ac
manias84029033mani_as
manikin132110243manikin
manila84518303manila_
manilas93915873manilas
mannan85413623man_nan
median94117543medi_an
medivac1554693medivac
menial84223033meni_al
mesian84315503mesi_an
midiron1046003midiron
mikvah18143473mi_kvah
milia72719573mili_a_
militant10411403militant
milkman1544913milkman
mimical1339233mimical
mina65136933min__a_
minae75627723min__ae
minas75434113min__as
mineral9312743mineral
mini65634573mini___
minibars1296553minibars
minibus1136343minibus
minicabs14135073minicabs
minicamp16124073minicamp
minicams14126873minicams
minicars12118523minicars
minify1439253mini_fy
minikins14208323minikins
minilabs12124573minilabs
minim97321603mini__m
minimals12327433minimals
minims104514813mini_ms
minimum10456143minimum
mining94225453mini_ng
minings103912073minings
minions93314623minions
minipark1643543minipark
minis75432993mini__s
minish115216313mini_sh
miniski1344483miniski
minium106014423mini_um
miniums113910223miniums
minivers1337483minivers
minyans1237263min_yans
mirin75023153miri__n
misgiven14245903misgiven
misplan1147773misplan
mitsvah1542163mitsvah
mitzvah2441783mitzvah
moneran9311113moneran
nival84915773__nival
pinion83815893pini_on
silvan92810153si_lvan
simian8811163simi_an
tinman82411143tin_man
titian62512663titi_an
wanigan1135213wanigan
wingman1336383wingman

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 Filter1786911340270.390458182.1
2DLD Change Limit134027956.83019623.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.25024647.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.