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

87 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
oomiaks134412(None) 
oomiacks1643531oomiacks
oomiacs1135681oomiacs
oomiak1235351oomiak_
oomiac1037062oomia_c
oomiack1544222oomiack
oompahs1434262oompahs
tombaks15246862tombaks
umiaks1244952_umiaks
amias75831473_amia_s
boinks125211273bo_inks
cobias104014993cobia_s
comake144413423com_ake
comakes154413643com_akes
comas95833003com_a_s
combats13311683combats
comics124015563comi_cs
comings124013533comings
commas124814573comma_s
compas125817063compa_s
compass13379563compass
domains10510873domains
domines102918973domines
dominos103210193dominos
fomites123613203fomites
goombahs1642523goombahs
goombays1642823goombays
hoicks15378283ho_icks
homies114524723homi_es
homines123518643homines
kaiaks937043_kaiaks
kamiks11387913kami_ks
lamias85020613lamia_s
micks135525373__micks
milks115020583__milks
minks115829273__minks
mirks115122143__mirks
momisms10308223momisms
mommas94110653momma_s
monomials1347303monomials
nomads94711603nom_ads
nomas74726413nom_a_s
nominals10278613nominals
nomisms11268743nomisms
norias65518203noria_s
oaks86527903_o__aks
obias76116863_obia_s
ohias84415573_ohia_s
oinks94819913_o_inks
omits75018263_omi_ts
oolites72817843oolites
ooliths10268323ooliths
oompah1334253oompa_h
oomphs1344723oom_phs
ootids71110353ooti_ds
osmics1036463osmi_cs
osmious936003osmious
osmiums1134143osmiums
romans84620243rom_ans
roomies93017243roomi_es
simians959203simians
smirks124910123_smirks
soaks95220293so__aks
socials999633socials
somans84619303som_ans
somas76030373som_a_s
somites94219123somites
soymilks1741403soymilks
tambaks15218153tambaks
tokomaks1342423tokom_aks
tomans85419133tom_ans
tombacks18216463tombacks
tombacs13248443tombacs
tombak14237753tombak_
tomcats11127773tomcats
umiacks1534013_umiacks
umiacs1035663_umiacs
umiak1137673_umiak_
umiaqs1733003_umiaqs
vomitos12217103vomitos
vomits112610923vomi_ts
vomitus12215743vomitus
womans114613653wom_ans
wombats1435893wombats
yoicks15375933yo_icks
zamias174212923zamia_s
zodiacs1943423zodiacs

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.406440125.6
2DLD Change Limit134027876.61020276.4
3Display Results87870.0302900.0
 (SQL Overall)178691877.04625360.6
 
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.