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

254 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
foisons104761(None) 
foison948931foison_
poisons9310351poisons
bisons83914372_bisons
bolsons969482bolsons
bosons85016652bo_sons
dobsons1036202dobsons
foins85523382foi__ns
foists95413982fois_ts
frissons1145042frissons
fusions1039152fusions
godsons966662godsons
grisons838992grisons
orisons7310562orisons
poison8312222poison_
prisons9313222prisons
unisons748422unisons
anions64123033ani_ons
arsons63917213_arsons
avions94114393avi_ons
avisos95410483aviso_s
axions134713483axi_ons
basions94213953basions
benisons1037043benisons
bison75716983_bison_
blousons1054403blousons
bolson8410683bolson_
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosoms104913053bo_soms
boson76019733bo_son_
bostons9312903bostons
bosuns8439383bo_suns
boutons9310783boutons
caissons1036283caissons
chitons122611913chitons
cions75222853_ci_ons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
coigns94410063coi_gns
coins75834553coi__ns
coitions10312853coitions
colons86028683co_lons
commons13311043commons
consols92914073consols
coons76737283co__ons
cordons104415763cordons
cosigns1047513cosigns
cottons9312193cottons
coupons112710563coupons
cousins9516003cousins
crimsons1245633crimsons
daikons12186693daikons
daimons10249323daimons
damsons1038013damsons
disowns1136733_disowns
doblons1037043doblons
dobson936593dobson_
donjons1536733donjons
eikons1038503_eikons
elisions82210423elisions
empoisons1343643empoisons
eosins64419163eo_sins
epigons1048183epigons
erosions8310343erosions
falcons1239123falcons
fanions103713073fanions
fanons96115213f_anons
fatsoes10379423fatsoes
fatsos9389423fatso_s
feigns10407753fei_gns
feijoas1742323feijoas
feists94915313feis_ts
felons93615763f_elons
ficins113513983f_icins
ficoes114613463f_icoes
fidos95819053f_ido_s
filos86125383f_ilo_s
finos86226953f_ino_s
fins75849093f_i__ns
firns86018543f_i_rns
fiscs105311883f_is_cs
fishes125221343f_ishes
fissions1138033fissions
fists85527543f_is_ts
flacons1238053flacons
flagons1137973flagons
foehns12204973fo_ehns
foetors1039763foetors
fogbows1643853fogbows
fogdogs1333263fogdogs
foghorns1544113foghorns
fohns117310783fo__hns
foibles1238853foibles
foiling113317653foiling
foils85025813foi__ls
foin77231563foi__n_
foining113013453foining
foist85730973fois__t
foisted113210603foisted
foisting122910503foisting
folios93915463folio_s
folious103710733folious
folksong1642463folksong
folksongs1741783folksongs
follows13409923follows
fons76943893f___ons
foods95924163fo__ods
fools86824203fo__ols
foots85528283fo__ots
fordoes11311963fordoes
fordone1149383fordone
forgoes11311353forgoes
forgone1139343forgone
formols12299413formols
forsook1446003forsook
foss76431643fo_s__s
fossas94610703fo_ssas
fosses96022083fo_sses
fossils10379013fossils
fourgons1234833fourgons
foxskins2242883foxskins
frisees104411693frisees
frises94124273fris_es
frisks13479263fris_ks
frisson1045313frisson_
frivols1334743frivols
frons86124043f__rons
frontons1136503frontons
fusion939773fusion_
futons93911513f_utons
gibsons1045043gibsons
gipons9389603_gipons
girons75014373_girons
godson857383godson_
goons65326773go__ons
gorgons938853gorgons
gossans836783gossans
gossoons944893gossoons
grison7310103grison_
guidons936623guidons
hoidens11329083hoidens
hoises94823673hois_es
hoising113414413hoising
hoists95516023hois_ts
horizons2045463horizons
hysons1237633_hysons
icons76516493__icons
ikons96311013__ikons
inions64417003ini_ons
ions46737853__i_ons
irons55324133__irons
johnsons1842383johnsons
joins125818413joi__ns
joists134711033jois_ts
kelsons1137323kelsons
lesions73813863lesions
lessons73811013lessons
liaisons844293liaisons
lions55923213_li_ons
logions86211293logions
logons79818173lo_gons
loins56728423loi__ns
loons55731723lo__ons
loosens716310953loosens
lotions74614763lotions
malisons1048773malisons
masons83916513_masons
mesons83215843_mesons
misos76523293_miso_s
moistens10268773moistens
monsoons1047343monsoons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
moutons9410313moutons
nasions73112383nasions
nelsons738003nelsons
ninons64913773_ninons
nitons64614903_nitons
noises65021853nois_es
noising83615173noising
noisome947973noisome
noons54125283no__ons
notions74014483notions
odeons739023_odeons
onions64016433_onions
opsins8411713_opsins
orison6411663orison_
orlons6411013_orlons
paisans93614753paisans
parsons93516873parsons
persons93717013persons
pinons86019943_pinons
pions75826393_pi_ons
pisos76021063_piso_s
pistons93016373_pistons
pitons85319043_pitons
plosions1038023plosions
pocosons1266103pocosons
podsols1056513podsols
poisers94214433poisers
poises84226543pois_es
poising103617103poising
poisoned1136953poisoned
poisoner1046983poisoner
poisoners1146113poisoners
poisonous1144073poisonous
pompons1338553pompons
pontons93315553pontons
poons75430973po__ons
potions93417423potions
prions84317783pri_ons
prison8514023prison_
ptisans9317363ptisans
raisins72715343raisins
ramsons939563ramsons
reasons72514943reasons
ronions73313343ronions
ronyons10258433ronyons
rosins64521863ro_sins
scions82612243sci_ons
seasons72614233seasons
seisins73614393seisins
seisors73212833seisors
solions7513753solions
solitons849593solitons
solons65120023so_lons
sons46049553___sons
sponsons1045813sponsons
telsons739213telsons
tigons74112263_tigons
tocsins939963tocsins
toons55027533to__ons
torsions839183torsions
torsos64815733torso_s
toyons95512133to_yons
trigons84312093trigons
tritons73814883tritons
unions64216753uni_ons
unison649033unison_
venisons1136133venisons
visions10311023_visions
visors92912223_visors
voudons1135323voudons
warisons1136903warisons
weasons102310583weasons
wontons103310533wontons
worsens104610263worsens
youpons12265983youpons
zoons144919693zo__ons

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272546.18621666.2
3Display Results2542540.0962645.8
 (SQL Overall)1786912546.43827755.7
 
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.