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

187 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
fynbos143328(None) 
fanos85926502fan_os
finos86226952fin_os
abos67734413__abos
adobos9438453adobos
ambos95321253_ambos
amnios84912523amnios
bancos104713893bancos
banjos15378893banjos
bentos86218303bentos
bilbos105011203bilbos
bimbos124610523bimbos
bingos95514793bingos
bonbon10310073bonbon
bonbons1139333bonbons
bongos95316653bongos
bonobos1136393bonobos
bos57966813___bos
buncos104011593buncos
bunkos124210323bunkos
cansos84915383cansos
cantos84826973cantos
carbos105122263carbos
centos85920463centos
combos125316613combos
condos94322333condos
congos94219883congos
contos84923233contos
cyclos1338073cyclos
cynics13377363cynics
danios7314603danios
dinos65428063din_os
dumbos114111083dumbos
dynamos1373853dynamos
dynels10536813dynels
dynes95917583dyn_es
eryngos1142733eryngos
fabs98635863f_ab_s
fados95620733f_ados
fandom122110893fandom
fandoms13229473fandoms
fanes84639893fan_es
fangas105017193fangas
fangs96224073fan_gs
fanion94514323fanion
fanions103713073fanions
fano75831693fan_o_
fanon84619013fan_on
fanons96115213fanons
fans76247373fan__s
fantod102010033fantod
fantods11177623fantods
fantom112110803fantom
fantoms12189153fantoms
fanums1137263fanums
faros85532023f_aros
fatsos9389423fatsos
feebs106112683feeb_s
fences114617113fences
fends96324973fen_ds
fens76139763fen__s
feyness1334923feyness
fibs96329503f_ib_s
fidos95819053f_idos
fillos94415083fillos
filos86125383f_ilos
finals94316163finals
fincas113512073fincas
finds95424823fin_ds
fines86644263fin_es
finis86824263fin_is
finks125424223fin_ks
fino76034693fin_o_
fins75849093fin__s
flabs105818643flab_s
flubs105515443flub_s
flyboy17113913flyboy
flyboys18112943flyboys
flybys1792773flybys
fobs96034273f_ob_s
fogbow1544783fogbow
fogbows1643853fogbows
folios93915463folios
fonds95824823fon_ds
fondus105210943fondus
fons76943893fon__s
fonts86124753fon_ts
forbs105720803forb_s
fubs96328793f_ub_s
fugios1037583fugios
funds94119253fun_ds
fundus10429173fundus
fungo94413133fungo_
fungoes11388813fungoes
fungous11367433fungous
fungus10418183fungus
funks125318913fun_ks
funs75235733fun__s
fyces139813643fy_ces
fykes156312693fy_kes
fylfot1545043fylfot
fylfots1642423fylfots
fyttes1236933fyttes
genros74211333genros
gobos86219383_gobos
gombos114311093gombos
gumbos114610873gumbos
gybes115012723gy_bes
gyros95616483gy_ros
hobos106321353_hobos
hydros13279363hydros
hypos1312014743hy_pos
infos84311673_infos
jumbos17379123jumbos
juncos15449233juncos
juntos134110843juntos
kendos114510663kendos
kenos95220623ken_os
kinos96626143kin_os
knobs11519713_knobs
kobos115616893_kobos
kybosh1842713ky_bosh
lenos56024863len_os
lentos65317403lentos
lesbos837403lesbos
limbos104712143limbos
linos55631503lin_os
lobos75921843_lobos
lynxes1634323lynxes
mambos125414493mambos
mangos94319333mangos
manos74933623man_os
mondos95217333mondos
mongos94318623mongos
monos75930863mon_os
mungos94311373mungos
mynahs14416443mynahs
mynas105815233myn_as
mythos14398463mythos
naos47429733__naos
nobs66436903__nobs
nos38859323__n_os
onos46229003_on_os
ovibos1145463ovibos
pantos85222743pantos
pengos94612413pengos
pingos95317673pingos
pinkos125313873pinkos
pintos86021293pintos
puntos85915793puntos
pyros105718293py_ros
rondos74616733rondos
rynds9569973ryn_ds
sambos104315193sambos
santos64421833santos
snobs74716153_snobs
sunbow1145823sunbow
sunbows1236023sunbows
sybo9714743sy_bo_
syboes1139343sy_boes
symbol1336083symbol
symbols1435523symbols
synchs14408453synchs
syncom1336093syncom
syncoms1435943syncoms
syncs104610173syn_cs
syngas10368913syngas
synod9610283syn_od
synods1077953synods
synths12377883synths
tangos74216303tangos
tondos75115923tondos
turbos8910783turbos
tynes85920303tyn_es
typos106015813ty_pos
tyros85118593ty_ros
umbos94613073_umbos
unbox1438753_unbox
uncos74117033_uncos
vinos84723073vin_os
winos84625043win_os
wynds126310373wyn_ds
wynns11517473wyn_ns
wyns105717033wyn__s
xystos16356913xystos
yobbos1335963yobbos
yobs96028083_yob_s

Search took 6 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.1701051123.5
2DLD Change Limit1127161875.72019705.6
3Display Results1871870.0632968.3
 (SQL Overall)1786911875.95330017.0
 
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.