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 “oxtaim” 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
oxtail1337651oxtail
foxtail1745382foxtail
obtain839182obtain
oxim131114052ox__im
oxtails1436382oxtails
aim57858223___aim
attain6311753attain
bobtail1146553bobtail
claim95616913_claim
contain9315833contain
detail74516433detail
detain74617383detain
entail61114343entail
exam132514623ex_a_m
exclaim1844943exclaim
extant132714753extant
foxtails1844583foxtails
litai55216363litai_
maim85831493__maim
misaim10311853misaim
obtains939163obtains
octad81510653octa_d
octadic1245713octadic
octads987333octads
octal71214723octa_l
octan71313483octa_n
octane81411633octane
octans81411143octans
octant81216553octant
octave11157343octave
octavo11124783octavo
ogam75120033o_ga_m
ogham1138253ogha_m
ontic74418573ont_ic
ootid61416703oot_id
optic93715183opt_ic
optima10106533opt_ima
optime1079353opt_ime
ordain7810403ordain
orgasm966303orgasm
ostia52315583ost_ia
ostium8310133ostium
otic66624823o_t_ic
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
outact8317203outact
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outbid91411863outbid
outdid81210923outdid
outfit93014953outfit
outgain81010743outgain
outhit92818473outhit
outlaid81110653outlaid
outlain71212613outlain
outlie62419533outlie
outrig72812853outrig
outsaid81210923outsaid
outsail71411413outsail
outsin63617563outsin
outsit63620893outsit
outswim1244843outswim
outvie92412803outvie
outwait10411763outwait
outwit93014593outwit
oxalic1537093oxalic
oxalis1339223oxalis
oxcart1539523oxcart
oxid12815493ox__id
oxidic1635943oxidic
oxime1498433ox__ime
oxims14107643ox__ims
oxlip1456883ox_lip
oxter123414093oxt_er
oxters134813273oxters
oxyacid2062773oxyacid
retail65522073retail
retain64523283retain
retrim83514883retrim
sextain14257103sextain
staid66722083_staid
staig65519643_staig
stain55727943_stain
stair54719943_stair
tail45443653__tail
tain45548073__tain
tam58663423__ta_m
tatami839193tatami
trim65329523__trim
untrim8310683untrim
voltaic1245453voltaic
voltaism1344813voltaism

Search took 7 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.373479064.3
2DLD Change Limit112716955.70319764.3
3Display Results95950.0332878.8
 (SQL Overall)178691956.10929250.5
 
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.