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

281 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
usances96737(None) 
usance858011usance_
usaunces1073371usaunces
chances145218092chances
dances95120652_dances
durances1158682durances
fiances12310672fiances
glances104113142glances
hances115621282_hances
lances84824102_lances
nances83618642_nances
nuances938522nuances
nuisances1145332nuisances
prances113618772prances
rances84625442_rances
saices84221802_saices
sanes55649072_san_es
sanies63031952_sanies
sauces84919502_sauces
seances93015342seances
stances93715962stances
trances93919642trances
usages759602usa_ges
usaunce9103382usaunce_
absences1247673absences
aces67645093__a_ces
acnes75922623__acnes
acutances1345763acutances
advances1445613advances
anankes1138763anankes
anes45255933__an_es
antes56334323__antes
asanas6514113asan_as
askance1345923askance_
auspices1236443auspices
balances1279973balances
bancos104713893_bancos
banes74945583_ban_es
beanies93821093beanies
blanches153311603blanches
bounces113813683bounces
braces108427773bra_ces
branches153613803branches
brisances1345843brisances
buoyances1643353buoyances
butanes9312743butan_es
calces104420053_calces
cancel105316683_cancel
cancels114113313_cancels
cancer104220923_cancer
cancers114018583_cancers
canes75350373_can_es
canoes84725883_canoes
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancels15439083chancels
chancer144215633chancer
chancers154313493chancers
chancres15429363chancres
changes134517583changes
cranches153114543cranches
cranes84330753cran_es
daces85030683_da_ces
dance85223133_dance_
danced105315253_danced
dancer94817613_dancer
dancers103413093_dancers
distances12311653distances
dunces95215753_dunces
durance1059113durance_
enhances1339293enhances
esnes54817363es_n_es
essences1047563essences
evinces1237803evinces
faces106439433_fa_ces
faeces114713123_faeces
falces115216003_falces
fancies124018783_fancies
fanes84639893_fan_es
farces115223323_farces
fasces114914543_fasces
fauces114916153_fauces
feasances1445403feasances
fences114617113_fences
fiance11310743fiance_
fiancee1238953fiancee
fiancees1335103fiancees
finances1338653finances
flanes94522423flan_es
flanges113413273flanges
francs114112193franc_s
furanes103214863furan_es
furnaces1336053furnaces
glaces94218033gla_ces
glance94312313glance_
glanced11439233glanced
glancer103710073glancer
glancers11408003glancers
glandes95413833glandes
graces94523493gra_ces
granges93516523granges
guidances1344773guidances
hance105424153_hance_
hanses95022633_hanses
inanes62519803inan_es
instances1148753instances
issuances1144643issuances
janes124928123_jan_es
jaunces16307423jaunces
joannes1436243joannes
jounces16369853jounces
joyances2044413joyances
justices1737523justices
kanes95529373_kan_es
laces76141763_la_ces
lance75126723_lance_
lanced93717723_lanced
lancer84319973_lancer
lancers93616643_lancers
lancet84223573_lancet
lancets93411163_lancets
lanes54946793_lan_es
launces9329003launces
lianes63819323lian_es
lucences12137313lucences
maces97139963_ma_ces
manches143818623_manches
manes76648963_man_es
manges94628943_manges
manses84225513_manses
mantes84430783_mantes
meanies93620743meanies
menaces112715523menaces
minces104420803_minces
nance74721843_nance_
nancies93516843_nancies
nonces84418833_nonces
nuance859043nuance_
nuanced1036203nuanced
nuisance1045713nuisance_
oranges84215333oranges
ounces83617773_ounces
outdances12198503outdances
outrances112912113outrances
paces96741113_pa_ces
panes76148693_pan_es
pannes85522853_pannes
peaces106324083pea_ces
penances12312443penances
places104323703pla_ces
plaices11411143plaices
planches153111863planches
planes85028083plan_es
ponces104720843_ponces
pounces114113893pounces
prance104318573prance_
pranced123714043pranced
prancer113613383prancer
prancers123210333prancers
princes113015143princes
puissances1443303puissances
pursuances1443453pursuances
quinces183210433quinces
races74943243_ra_ces
rance75028513_rance_
ranches123620113_ranches
ranees64623963_ranees
ranges73826923_ranges
romances12310793romances
rubaces1139313ruba_ces
sabes76437463_sa_bes
sables85026693_sables
sabres85520863_sabres
sacks114228873_sa_cks
sacs65739073_sa_c_s
sades65239893_sa_des
sadhes104715373_sadhes
safes85226723_sa_fes
sages65339063_sa_ges
saice75424053_saice_
sakes95540753_sa_kes
sales56055593_sa_les
salves94221763_salves
sancta839833_sancta
sanded84920613_sanded
sander74828533_sander
sanders84025943_sanders
sands65228583_san_ds
sane45954343_san_e_
saned65636273_san_ed
saner54334323_san_er
sanest64426693_san_est
sangas75222653_sangas
sanger74524563_sanger
sangers84421943_sangers
sanghs105312063_sanghs
sanicles10149943_sanicles
sans45153363_san__s
sansei63411903_sansei
sanseis73011603_sanseis
santos64421833_santos
sarees65329943_sarees
sarges75128593_sarges
sashes94728483_sashes
sasses64124393_sasses
sates54949323_sa_tes
sauce75121653_sauce_
sauced93913303_sauced
saucer84314103_saucer
saucers93712133_saucers
sauchs115112233_sauchs
sautes63924913_sautes
saves85838633_sa_ves
saxes125229343_sa_xes
sconces113811453sconces
seance83716693seance_
senses63923943_senses
sices75637273_s_ices
since75024173_since_
sines55954823_sin_es
singes74326853_singes
slices84022853_slices
snacks124514553_snacks
snakes103919603_snakes
snares65329033_snares
snyes85012753_s_nyes
sonances10310263sonances
sondes74922873_sondes
sones55444143_son_es
spaces104722633_spaces
spancel1147363spancel
spancels1245273spancels
spences113413923spences
spices104326033_spices
stance84316913stance_
stanches132312793stanches
stanes64933403stan_es
substances1446323substances
syces106416463_s_yces
synced12266963_synced
synchs14408453_synchs
syncs104610173_sync_s
taces76237803_ta_ces
tenaces92814513tenaces
thanes94918983than_es
tisanes7311853tisan_es
traces85329933tra_ces
trance84718763trance_
tranced104414173tranced
tranches132915513tranches
tsades74310993tsa_des
ukases10358063uka_ses
ulans54921303ulan__s
uncles8317163u__ncles
uncos74117033u__ncos
uncus74014983u__ncus
unfences1337933unfences
unlaces92513623unlaces
upases84112903upa_ses
uranias72113813uranias
uranides92211283uranides
uranites82514643uranites
uranous7310733uranous
uranyls1034453uranyls
urares64519093ura_res
urases63723563ura_ses
urates65027763ura_tes
urines64724123urin_es
usable84012553usable_
usage6410213usa_ge_
uses44931113us___es
usnea539393us_n_ea
usneas638333us_neas
usques15126803us_ques
usuries7510633usuries
valances1398763valances
vanes85130973_van_es
wanes85040883_wan_es
winces114819113_winces
zanies153219673_zanies

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.813219792.1
2DLD Change Limit1340272816.62620227.4
3Display Results2812810.0933021.5
 (SQL Overall)1786912817.53223724.2
 
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.