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

199 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
ceboids123765(None) 
cebids11439161ceb_ids
ceboid11310651ceboid_
cuboids1236721cuboids
cebid104314062ceb_id_
cestoids11308272cestoids
cheloids1438022cheloids
conoids10813882conoids
cuboid1139502cuboid_
geoids8369842ge_oids
keloids1288662keloids
meloids10911442meloids
rebids94015522reb_ids
reboils94111712reboils
adenoids1056843adenoids
ambroids1346473ambroids
ameboid1277223ameboid_
aneroids9310183aneroids
aroids75118223_aroids
avoids104410203_avoids
bebloods13115233bebloods
bebops1237623bebo_ps
beholds1336423beholds
beyonds1335063beyonds
bids75838423__b_ids
bods76244713__bo_ds
boils75427193__boils
bolds85825283__bolds
bonds86126843__bonds
bovids1287973__bovids
cabbies133115163cabbies
cabins104418913cab_ins
cabobs124311883cabo_bs
caids85226423c__aids
candids113812693candids
canids95118133c_anids
capsids1239333capsids
carotids11229933carotids
catenoids1246423catenoids
cedis84317083ce_di_s
ceilidh1345363ceilidh
ceilidhs1442133ceilidhs
ceilis85413743ceili_s
ceils75019403ce__ils
celoms10412123celo_ms
celosias1048903celosias
cenotes92814543cenotes
centroids1247033centroids
ceorls848163ce_orls
cepheids1644243cepheids
cercis104614493cerci_s
cerias83321973ce_rias
ceros74726073cero__s
cerous85821203cero_us
cervid1239323cervid_
cestoid104011673cestoid_
cheloid13310823cheloid_
chlorids14299663chlorids
choirs114911873c_hoirs
chords125214633c_hords
choroids1438683choroids
cibols1039523cibo_ls
cissoids1145363cissoids
clerids1049083clerids
clods85320863c_lo_ds
clouds94612353c_louds
cobias104014973cob_ias
coccids11277213coccids
coccoids12176793coccoids
cods76848103c__o_ds
coeds85920163c__oeds
coifs105718703c__oifs
coils75030083c__oils
coins75834553c__oins
coirs75221053c__oirs
cojoins1638993cojoins
colds85726973c__olds
colloids11310173colloids
conoid9818883conoid_
cords86030623c__ords
corvids1337673corvids
cosmids1237633cosmids
cricoids1347183cricoids
crinoids1147353crinoids
crowds124910763c_rowds
ctenoid1078683ctenoid_
cubbies133312883cubbies
cubics123810153cub_ics
cubits103714023cub_its
cuboidal1344243cuboidal
cupids11369193c_upids
cuspids12427113cuspids
cyanids13297933cyanids
cyborgs1542763cyborgs
cycloids1647033cycloids
cymoid1459463cymoid_
cystoids14306733cystoids
debits94214493deb_its
debones103315113debones
debride1138593debride
debrides1268723debrides
debris93311493debri_s
deltoids1045483deltoids
dermoids1246153dermoids
desmids1166603desmids
desmoids1244973desmoids
devoid1189353devoid_
devoirs1175783devoirs
droids84712583_droids
ebonics1137183_ebonics
ebonies9312883_ebonies
ebons74316093_ebo_ns
ebooks12358333_ebooks
ecbolics1443993ecbolics
eloins65419383_eloins
emeroids11147713emeroids
equids16439143_equids
felids103111623fe_lids
feods99516853fe_o_ds
fibroids1445833fibroids
fucoids1335663fucoids
gadoids1036863gadoids
ganoids939323ganoids
geoid74215753ge_oid_
globoids1244413globoids
gobioids1243873gobioids
haloids113012543haloids
hemoid12313513hemoid_
heroics122912003heroics
heroins103518013heroins
hybrids16236013hybrids
hyoids1377673_hyoids
iceboats1244963iceboats
iceboxes1943533iceboxes
jerids142810943je_rids
jerrids15277743jerrids
kebbies1537253kebbies
kebobs14427283kebo_bs
keloid11812613keloid_
kobolds1474343kobolds
labroids1155833labroids
lentoids947443lentoids
leporids1145673leporids
lipoids1038233lipoids
loids66220703__loids
meloid9615993meloid_
memoirs1136803memoirs
mucoids1237413mucoids
negroids10116323negroids
nereids838743nereids
nevoid1098793nevoid_
oceloid1037963oceloid_
opioids1036523opioids
ovoids10456923_ovoids
peptids12239323peptids
percoids1339663percoids
periods10312243periods
peroxids1837443peroxids
prebids12399873preb_ids
preboils1267273preboils
rebaits9312573rebaits
rebid85121353reb_id_
rebinds104511873rebinds
reboards1138773reboards
rebodies1139153rebodies
rebody1238153rebo_dy
reboil83814683reboi_l
rebooks134010513rebooks
reboots93512093reboots
rebops10311423rebo_ps
rebores95319163rebores
rebounds1156023rebounds
rebozos1835143rebozos
rebuilds1143503rebuilds
recoils93814873recoils
recoins94019243recoins
records105213923records
refolds11298953refolds
rejoins143111383rejoins
reloads8911313reloads
remolds10299703remolds
reoils64516873re_oils
resids74219153re_sids
resods74116303reso_ds
rewords115413973rewords
seconds1038283seconds
sloids73712693_sloids
steroids9911433steroids
tabloids1146143tabloids
teiids736693te_iids
toroids8310643toroids
toxoids1535213toxoids
upboils1184703upboils
verbids13259203verbids
vespids1334613vespids
viroids1137923viroids
voids95414673__voids
zebroid1936463zebroid_
zooids1637093_zooids

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.1531167915.0
2DLD Change Limit1340271997.61017612.0
3Display Results1991990.1431391.6
 (SQL Overall)1786911997.90622601.9
 
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.