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 “minibus” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

147 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
minibus113633(None) 
manitus9310922manitus
milieus939802milieus
minibar11106132minibar
minibars1296542minibars
minibuses1344792minibuses
minims104514812mini_ms
minimum10456142minimum
minimums11404592minimums
minings103912072minings
minions93314622minions
minis75432992mini__s
minium106014422mini_um
miniums113910212miniums
minus75223932min__us
omnibus1152982omnibus
airbus848343ai_rbus
animus84211613_animus
bilious9310933bilious
binits85716673bini_ts
dingus83611843din_gus
finials103210153finials
finings114311773finings
finis86824263fini__s
finises10312903finises
finites10315923finites
genius74512923geni_us
iambus10468903_iambus
imbibes1334693imbibes
impious1137063impious
incubus1144743_incubus
incus73315053_in_cus
inions64417003_inions
kinins104014583kini_ns
limbus105710383li_mbus
linings84313073linings
linins65922143lini_ns
maniacs114313063maniacs
manias84029033mani_as
manics103919933mani_cs
manilas93915873manilas
maniocs113611443maniocs
manitos9314053manitos
manitous1039173manitous
manitu8315823manitu_
manus75924923man__us
medius93613283medi_us
meinies92516073meini_es
menials94015683menials
meniscus1243773meniscus
menus75822843men__us
miaous8511693mi_aous
mibs85330483m__ib_s
microbus1456033microbus
midis85923413midi__s
midribs1235503midrib_s
milieu8314113milieu_
milieux1643783milieux
milium104712683mili_um
milnebs11113793milneb_s
mimics1289363mimi_cs
minable112315073minable
minacious1346173minacious
minas75434113min__as
mincers113714843mincers
minces104420803min_ces
minders103720113minders
mindful1344613mindful
minds85427123min__ds
miners84126633min_ers
mines75651953min__es
mingles103719003mingles
mini65634553mini___
minibike1653793minibike
minibikes1743693minibikes
minibusses1442273minibusses
minicab13177163minicab
minicabs14135063minicabs
minicam131110053minicam
minicams14126863minicams
minicar11109313minicar
minicars12118503minicars
minidisc1344133minidisc
minifies13312893minifies
minify1439253mini_fy
minikin13258983minikin
minikins14208313minikins
minilab11126003minilab
minilabs12124573minilabs
minim97321603mini__m
minima105512643mini_ma
minimal114010593minimal
minimals12327423minimals
minimax18376003minimax
minimise1246863minimise
mining94225453mini_ng
minion83416243mini_on
minish115216303mini_sh
minishes13310583minishes
miniski1344483miniski
miniskis1444443miniskis
minivan1245713minivan
minivans1345413minivans
miniver1238393miniver
minivers1337473minivers
minkes124618783min_kes
minks115829273min__ks
minnies93617363minnies
minnows1234913minnows
minors85117093min_ors
minters93822463minters
mints76834043min__ts
minuets9259853minuets
minuses93512703minuses
minutes93513433minutes
minxes154612983min_xes
minyans1237263minyans
mirins83918903miri_ns
misbias1139083misbias
missus85312293mi_ssus
mitis75425993miti__s
mitises9315543mitises
mittimus1243023mittimus
mixible18195093mixible
monies83233163moni_es
monisms113512803monisms
monists93614783monists
munis75022003muni__s
nibs65028313__nib_s
nidus65913573__nidus
nimbus10377283ni_mbus
nimious937663nimious
nisus56014393__nisus
ominous949023omin_ous
pinions93413603pinions
pinites9319533pinites
ricinus9408123ricinus
sanious7514103sanious
simious939803simious
sinuous739063sinuous
sinus55523853sin__us
snibs75613763_snib_s
tinnitus843783tinnitus
vicious1239493vicious
vinous93914173vin_ous
zincous1837053zincous
zinebs17606803zineb_s

Search took 10 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.1561145455.1
2DLD Change Limit1340271479.54614040.1
3Display Results1471470.0602450.0
 (SQL Overall)1786911479.76218304.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.