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

153 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
oomiak123535(None) 
oomiac1037061oomiac
oomiack1544221oomiack
oomiaks1344121oomiaks
oomiacks1643532oomiacks
oomiacs1135682oomiacs
oompah1334252oompah
tombak14237752tombak
umiak1137662_umiak
amia66836893_amia_
amias75831463_amias
boink115516333bo_ink
bombax1935753bombax
boomier113312183boomier
booming123716223booming
cobia94117503cobia_
cobias104014973cobias
coma87134853com_a_
comae97128423com_ae
comake144413423com_ake
comal95125133com_al
comas95833003com_as
combat12316753combat
comic114721813comi_c
comical13312223comical
comics124015563comics
coming114225453coming
comity13312713comity
comix163513193comi_x
comma114514793comma_
commas124814573commas
compas125817063compas
coria75828303coria_
domain9511323domain
domal85619203dom_al
domic104317243domi_c
domical1239373domical
domine92918253domine
doming104218393doming
domino92611493domino
doomier103610123doomier
doomily1336133doomily
dooming113112533dooming
eolian6312593eolian
eonian6311833eonian
folia83618933folia_
foliar93210973foliar
fomite113314073fomite
gonia64117533gonia_
goombah1543113goombah
goombay1543553goombay
gopik1257533gopi_k
hoick145210683ho_ick
homie104622523homi_e
homier116416993homier
homies114524723homies
homily144712333homily
homing123718383homing
hominy144511483hominy
jovial1636543jovial
kaiak8310353_kaiak
kamik105011553kami_k
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
logia68116603logia_
looming102814853looming
mick126333423__mick
milk105028463__milk
mink106636513__mink
mirk106729493__mirk
momi87524483momi__
momism93410353momism
momma85111053momma_
mommas94110653mommas
monomial12410133monomial
noma67529463nom_a_
nomad86016183nom_ad
nomas74726413nom_as
nomina83113683nomina
nominal92712373nominal
nomism103010953nomism
noria55722183noria_
norias65518183norias
oak76238653_o__ak
obia67923103_obia_
obias76116853_obias
ohia75719363_ohia_
ohias84415563_ohias
ohmic1237833ohmi_c
oidia6314953oidia_
oink85429343_o_ink
omit65337363_omi_t
omits75018253_omits
oohing104412933oohing
oolite63319603oolite
oolith93813243oolith
oompahs1434263oompahs
oomph1236973oom_ph
oomphs1344723oomphs
oorie53026363oori_e
ootid61416693ooti_d
ootids71110353ootids
oozier153610253oozier
oozily18328073oozily
oozing163812203oozing
orgiac934993orgiac
osmic939913osmi_c
osmics1036463osmics
osmium1036573osmium
ossia53710403ossia_
ostia52315583ostia_
podia8415283podia_
roman75424823rom_an
roomie83013873roomi_e
roomier93812243roomier
roomies93017243roomies
roomily1237283roomily
rooming104117043rooming
simian8811153simian
smirk116612743_smirk
soak87227663so__ak
social8813333social
soma65635293som_a_
soman75024903som_an
somas76030373som_as
somital939403somital
somite84519373somite
soymilk1642363soymilk
tambak14249263tambak
tokomak1243253tokom_ak
toman75724053tom_an
tombac12258883tombac
tomback17227743tomback
tombaks15246853tombaks
tombal102311023tombal
tomcat101013453tomcat
umiac938953_umiac
umiack1435173_umiack
umiaks1244953_umiaks
umiaq1656813_umiaq
vomica1336383vomica
vomicae1445303vomicae
vomit102622573vomi_t
vomito11238033vomito
vomits112610923vomits
woman105818003wom_an
wombat1339863wombat
yomim12510073yomi_m
zamia165115213zamia_
zamias174212923zamias
zodiac1835303zodiac
zooming19269653zooming

Search took 9 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161537.79614458.2
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.99922339.2
 
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.