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

141 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
oocyte113575(None) 
oocytes1246061oocytes
gonocyte1454872gonocyte
locate83919842locate
monocyte1547892monocyte
oocyst1136132oocyst
oocysts1243922oocysts
oolite63319602oolite
oophyte1545632oophyte
acolyte12157653acolyte
acute74720363_acute
anolyte10159003anolyte
baryte115312883baryte
bocce114313113boc_ce
boccie123311453boccie
boche124216953boc_he
boite74426323bo_ite
bolete8519613bolete
borate85026153borate
byte96521813__byte
cate66254603__cate
cete64934783__cete
cite65640343__cite
cockle143913573cockle
cocotte1138603cocotte
coenocyte1644333coenocyte
colocate12313443colocate
comate104124843comate
comte96125473co_mte
conte76633203co_nte
cote66648733__cote
cotype1346823cotype
coyote11411783coyote
cute66440453__cute
cyme119420373__cyme
dacite91115883dacite
docile94213123docile
docket134721173docket
donate73619503donate
dote55442883do__te
eocene8311613eocene
excite15310883excite
facete115014833facete
flyte115713943_flyte
folate93320393folate
fomite113314073fomite
forte86131463fo_rte
gonocytes1544733gonocytes
hemocyte1846433hemocyte
hoochie1537803hoochie
horste94817413horste
hoyle11314413ho_yle
hyte109018943__hyte
incite83618733incite
iodate7313503iodate
iolite63221983iolite
jocose1537103jocose
kyte117017763__kyte
lipocyte1544303lipocyte
lobate82915243lobate
locale83915653locale
located103114183located
locater93113603locater
locates93218813locates
locket123922473locket
locule83412033locule
lotte54923853lo_tte
lucite8313343lucite
monocytes1647973monocytes
monte75829773mo_nte
moste75925083mo_ste
mote67048083mo__te
motte75526973mo_tte
myxocyte2573153myxocyte
norite63221133norite
notate63217863notate
note46239963no__te
oblate82214743oblate
obovate1235463obovate
ochre103411593_ochre
octet7324063_oc_tet
octyl10136063_octyl
odonate848403odonate
odyle9349593_odyle
oleate6318883oleate
once65423083onc__e
oncet74626543oncet_
oolites72817843oolites
oolith93813243oolith
oophytes1646033oophytes
oorie53026363oo_rie
oot311274693oo__t_
oots46446443oo__ts
ooze136420603oo__ze
oozy167018133oozy__
ophite11410563ophite
opiate8513463opiate
orate55133303_orate
ornate6315143ornate
oscine8311563oscine
oscule838193oscule
osteocyte1453433osteocyte
otocyst1244833otocyst
otocysts1343503otocysts
outate62923403outate
ovate84214393_ovate
oxeye1536913oxey_e
ozonate1646863ozonate
pocket144622623pocket
podite93315353podite
pointe84619313pointe
polite83625073polite
qubyte2034243qubyte
recite83625113recite
rochet115423003rochet
rocket125425283rocket
rotate63320343rotate
rote46249023ro__te
rotte54625933ro_tte
route55132073ro_ute
scute75520943_scute
scythe14466013_scythe
socage91012123socage
socket123923523socket
socle7419573soc_le
solate64526073solate
solute64016663solute
somite84519373somite
sopite84917713sopite
toccate1138773toccate
togate74515683togate
torte55431703to_rte
tote46643673to__te
uncute82912133uncute
vacate11314553vacate
volte85321303vo_lte
volute93912763volute
vote74728623vo__te
wyte106018643__wyte
zonate154114923zonate
zoophyte2544603zoophyte

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.376475242.0
2DLD Change Limit1127161415.78019501.0
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.20228811.8
 
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.