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

221 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
fixures1759606(None) 
figures11239111figures
fixtures1835281fixtures
fixure16256541fixure_
failures1135162failures
fiacres1237252fiacres
fibres114312122fi_bres
ficuses12159202ficuses
figure10258832figure_
figured12196472figured
figurer11215862figurer
figurers12254872figurers
fiques1837972fiqu_es
fires85740752fi__res
fissures1136572fissures
fixates1737392fixates
fixers165112982fixer_s
fixes154723592fix__es
fixture1734962fixture_
flexures1843422flexures
futures10310262futures
inures63318952_inures
ligures8269892ligures
mixtures1735752mixtures
abjures1636523abjures
adjures1536233adjures
affixtures2351783affixtures
allures72913113allures
armures9510273armures
assures7611403assures
aures55137093__aures
azures15510183_azures
bistres94017213bistres
cires74932913ci__res
colures9315143colures
cures75645433__cures
dilutes82911973dilutes
disuses84015413disuses
dures65635923__dures
endures83314603endures
ensures73315903ensures
enures63919713_enures
epicures1246513epicures
exudes143710363_exudes
exurbs1534423_exurbs
factures13129023factures
failure1035753failure_
fares85852873f__ares
fauces114916153f_auces
fauves125610423f_auves
favuses1336183favuses
faxes155726653fax__es
features11310333features
femurs1136713femur_s
feres86038183f__eres
ferules103112723ferules
fetuses10310243fetuses
fiacre1137623fiacre_
fiances12310673fiances
fiars86720833fi_ar_s
fibbers144510603fibbers
fibered1337643fibered
fibers114717523fiber_s
fibre104812843fi_bre_
fibulas12228563fibulas
fices106031163fi__ces
fiches145219533fi_ches
ficoes114613463fi_coes
ficus105015493ficu__s
fiddles123212603fiddles
fidges114114393fi_dges
fifers125414923fifer_s
fifes114822393fi__fes
fifties132111083fifties
figural1145243figural
figurines1344503figurines
filaree10611213filaree
filarees1187643filarees
filatures1245853filatures
filches153410723filches
filers94623723filer_s
files85441273fi__les
fillers104320213fillers
filles94224523fi_lles
fillies103420253fillies
filmers124211293filmers
filters103816553filters
fimbles143510663fimbles
finales104016013finales
finches153914193finches
finders113717873finders
fineries112416743fineries
fines86644263fi__nes
fingers113418433fingers
finises10312903finises
finites10315923finites
fiords10498623fi_ords
fipples14298653fipples
fique1739143fiqu_e_
fire76245593fi__re_
fired94829743fi__red
firer811229253fi__rer
firers94922683fi__rers
firmers124711443firmers
firms105217423fi__rms
firns86018543fi__rns
firs76637713fi__r_s
fishers134714723fishers
fishes125221343fi_shes
fissure1036783fissure_
fissured1235183fissured
fitches153516193fitches
fitters104517753fitters
fivers124420923fiver_s
fives116027363fi__ves
fixate1638733fixate_
fixated1835533fixated
fixed165416953fix__ed
fixer154717833fix__er
fixings18347443fixings
fixities1838213fixities
fizzers18357003fizzers
fizzes174512553fi_zzes
fizzles18339063fizzles
flares94521703f_lares
flexure1743413flexure_
floured11289873floured
flours94414053flour_s
flues84626923f_lu_es
flukes135114193f_lukes
flumes115119733f_lumes
flutes95421783f_lutes
fluxes165212933f_luxes
focuses12159653focuses
fores85847103f__ores
fours85521493f_our_s
foxes156321093fox__es
foxfires2142813foxfires
freres94716173f_reres
fucuses12158353fucuses
fugues104511683fugu_es
fumes105224703f__umes
furfures1445663furfures
furies95126373f__uries
furls85322053f__urls
furores10310033furores
furs76735043f__ur_s
furzes186613693f__urzes
fuses85628423f__uses
future939563future_
fuzes175120223f__uzes
gigues8129003gigu_es
guipures1143733guipures
hires86134343hi__res
immures1136713immures
injures143111173injures
insures73117263insures
inure54119053_inure_
inured73114813_inured
inurns63310983_inurns
ires45639283_i__res
ixoras1337193_ixoras
ixtles13217063_ixtles
leisures836683leisures
lemures938793lemures
ligules82210923ligules
ligure7279473ligure_
litres65220393li_tres
livres94311863li_vres
lures56138533__lures
luxuries1544793luxuries
manures9313353manures
matures9314303matures
minuses93512703minuses
minutes93513443minutes
mires75640883mi__res
misuses93216023misuses
mitres83922073mi_tres
mixers154513563mixer_s
mixes147224403mix__es
mixture1635413mixture_
mixups1743263mixu_ps
mures75937223__mures
natures7311963natures
nexuses1436743nexuses
niduses837013niduses
nitres65519333ni_tres
nixes124519623nix__es
nixies135313873nix_ies
ordures856473ordures
parures9512693parures
pictures1249343pictures
pilules9510623pilules
piques1739093piqu_es
pixes144323173pix__es
pixies154915513pix_ies
rasures7312013rasures
refigures1344543refigures
risuses73210923risuses
secures9613163secures
seisures838273seisures
seizures1744633seizures
sieurs659043sieur_s
sinuses73011593sinuses
sires55945373si__res
situses72710493situses
sixes124526363six__es
sixtes133612403six_tes
sixties14310973sixties
soilures836503soilures
stoures74614163stoures
sutures7314223sutures
tenures7412013tenures
textures1597523textures
timbres11249353timbres
tires55437493ti__res
titres64718933ti_tres
velures1039093velures
vires84529683vi__res
viruses1039413viruses
wires86034913wi__res

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.406440125.6
2DLD Change Limit1340272215.83022989.2
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.31228309.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.