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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

93 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
oxid1281548(None) 
oxide131210951oxide
oxids13128961oxids
oxim131114041oxim
acid77533392acid
aid49269072_aid
amid77036332amid
arid57642712arid
avid88325962avid
axed128829612axed
axil116424452axil
axis116127912axis
bid67751782_bid
bovid111011622bovid
boxed154318612boxed
caid77837532caid
chid106626402chid
coxed154322812coxed
did56850512_did
dioxid1568392dioxid
doxie136017152doxie
exed125420592exed
exit114428672exit
fid76847682_fid
foxed165115212foxed
gid57047262_gid
grid65829612grid
guid66022822guid
hid76248362_hid
id38941832__id
imid76122272imid
iodid74315522iodid
irid55927162irid
ixia115713202ixia
kid86540612_kid
laid56439142laid
lid47453512_lid
loid55531482loid
loxed135017052loxed
maid75537632maid
mid67354452_mid
moxie144018122moxie
obi57127722obi_
obia67923102obia
obis66226832obis
obit66837072obit
od39255242o__d
odd57725452o_dd
odic74920572odic
ohed87825182ohed
ohia75719362ohia
oi29061482o_i_
oil37452052o_il
old47033462o_ld
olio46829672olio
omit65337362omit
ootid61416692ootid
oped76230152oped
orad56031692orad
otic66624812otic
oud47439072o_ud
ovoid94811022ovoid
owed86833872owed
ox98242382ox__
oxen116218592oxen
oxes116530722oxes
oxides14109692oxides
oxidic1635942oxidic
oxime1498432oxime
oxims14107642oxims
oxlip1456882oxlip
oxo107322962ox_o
oxy136320982ox_y
paid75737482paid
poxed154817862poxed
qaid146023842qaid
quid144922352quid
raid55243072raid
rid46754622_rid
said55742112said
skid95720912skid
slid55828982slid
solid65025072solid
toxic145315622toxic
toxin124716712toxin
toxoid1438152toxoid
vid77241802_vid
void86220562void
whid115418872whid
xi98128162_xi_
xis106935332_xis
yid76640822_yid
zooid15312102zooid

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit29872930.87334217.6
3Display Results93930.0165812.5
 (SQL Overall)178691930.965185172.0
 
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.