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

294 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
usance85801(None) 
usances967371usances
usaunce9103381usaunce
askance1345922askance
chance134617092chance
dance85223132_dance
durance1059112durance
fiance11310742fiance
glance94312312glance
hance105424152_hance
lance75126722_lance
nance74721842_nance
nuance859042nuance
nuisance1045712nuisance
prance104318572prance
rance75028512_rance
saice75424052_saice
sane45954342_san_e
sauce75121652_sauce
seance83716692seance
since75024172_since
stance84316912stance
trance84718762trance
usable84012552usable
usage6410212usa_ge
usaunces1073372usaunces
absence1137713absence
ace59656833__a_ce
acne66625873__acne
acutance1246303acutance
advance1346043advance
alane56135613alan_e
ananke1038283ananke
ane37866953__an_e
ante46538903__ante
apace94718383apa_ce
asana5315483asan_a
asanas6514113asanas
auspice1136523auspice
balance11510263balance
banco94019393_banco
bane65250433_ban_e
beanie83618593beanie
blanch133410853blanch
bounce104014833bounce
brace95629273bra_ce
branch134014773branch
brisance1245953brisance
buoyance1543713buoyance
butane8313653butan_e
cancel105316683_cancel
cancer104220923_cancer
cane66653123_can_e
canoe75627253_canoe
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
chancy164010863chancy
change124116753change
cranch133613533cranch
crane75331603cran_e
dace76934923_da_ce
danced105315253_danced
dancer94817613_dancer
dances95120653_dances
distance11311853distance
dunce86319263_dunce
durances1158683durances
enhance1239693enhance
esne47018793es_n_e
essence947673essence
evince1137763evince
face96140123_fa_ce
fancy134615483_fancy
fane75343573_fan_e
farce104925323_farce
feasance1345823feasance
fence105319913_fence
fiancee1238953fiancee
fiances12310673fiances
finance1238573finance
flange103411973flange
franc104615413franc_
francs114112193francs
furane94015493furan_e
furnace1235943furnace
gane55145303_gan_e
glace87420153gla_ce
glanced11439233glanced
glancer103710073glancer
glances104113143glances
grace85124543gra_ce
grange83716203grange
guidance1244983guidance
hances115621283_hances
hanse85722793_hanse
hence104920043_hence
humane112812173human_e
inane52820343inan_e
insane6314893insan_e
instance1049883instance
issuance1045223issuance
jane115031483_jan_e
jaunce15367433jaunce
jounce153310733jounce
joyance1944773joyance
justice1637423justice
kane85133973_kan_e
lace66848473_la_ce
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
lane45153333_lan_e
launce8469183launce
liane54720663lian_e
lucence11148003lucence
mace87345793_ma_ce
manche133515103_manche
mane65052033_man_e
mange84930193_mange
manse75528233_manse
meanie83718393meanie
menace103216943menace
mince95325233_mince
nances83618643_nances
nancy105214923_nancy
nonce75719823_nonce
nuanced1036203nuanced
nuances938523nuances
nuisances1145333nuisances
once65423083__once
orange74016323orange
ounce77019933_ounce
outdance11238733outdance
outrance102212783outrance
pace86345773_pa_ce
pane64950293_pan_e
panne76623653_panne
peace95026083pea_ce
penance11313443penance
pence94924453_pence
place94824613pla_ce
plaice10311553plaice
planch133711443planch
planche14299753planche
plane74929143plan_e
ponce95222513_ponce
pounce105214093pounce
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prince104114763prince
puissance1343783puissance
pursuance1344093pursuance
quince173910133quince
race66746263_ra_ce
rances84625443_rances
ranch105019793_ranch
ranee55438103_ranee
range64728413_range
romance11311083romance
rubace10310173ruba_ce
rusine63916593rusin_e
sabe66140573_sa_be
sable74732163_sable
sabre74821503_sabre
sac57452863_sa_c_
sack105337313_sa_ck
sacs65739073_sa_cs
sade55544473_sa_de
sadhe94815133_sadhe
sae38365183_sa__e
safe75930953_sa_fe
sage55044593_sa_ge
saices84221803_saices
sake85244963_sa_ke
sale44959703_sa_le
salve85022133_salve
same65245643_sa_me
sancta839833_sancta
sand55338473_san_d
sanded84920613_sanded
sander74828533_sander
sands65228583_sands
sandy94221133_sandy
saned65636273_saned
saner54334323_saner
sanes55649073_sanes
sang55441233_san_g
sanga66023793_sanga
sanger74524563_sanger
sangh95517453_sangh
sanicle91210263_sanicle
sanies63031953_sanies
sank85236833_san_k
sans45153363_san_s
sansei63411903_sansei
santo56227283_santo
saree55044663_saree
sarge65531133_sarge
sate45556103_sa_te
sauced93913303_sauced
saucer84314103_saucer
sauces84919503_sauces
sauch104918773_sauch
saucy104615163_saucy
saute55028083_saute
save75741363_sa_ve
scarce104013633scarce
sconce104711723sconce
seances93015343seances
sene46848053_sen_e
sense55526823_sense
sente56432883_sente
sice65545593_s_ice
sine46560623_sin_e
singe65731133_singe
slice74925823_slice
snack114718063_snack
snake94821113_snake
snare54429983_snare
snye77115493_s_nye
sonance9310313sonance
sonde64622833_sonde
sone46649983_son_e
space95325673_space
spancel1147363spancel
spence103813793spence
spice95528813_spice
stances93715963stances
stanch113812373stanch
stane55933003stan_e
suable83920553suable
suave83519873sua_ve
substance1346753substance
syce95820283_s_yce
sync95415103_sync_
synced12266963_synced
synch135011793_synch
syncs104610173_syncs
syne75725763_syn_e
tace65342513_ta_ce
tenace82715693tenace
thane86122533than_e
thence112010843thence
tisane6311573tisan_e
trace75829613tra_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
tsade64311123tsa_de
ukase9428493uka_se
ulan46527393ulan__
ulans54921303ulan_s
ulnae55214573u_lnae
unable83819223unable
unbe65319273u__nbe
unci65019463u__nci
uncle7317053u__ncle
unco66021403u__nco
unde55825483u__nde
unfancy1545203unfancy
unfence1239193unfence
unlace82215173unlace
unsafe9310693unsa_fe
unsoncy1245513unsoncy
urania62516123urania
uranic82315183uranic
uranide82212093uranide
uranite72515693uranite
uranyl936293uranyl
urare56322553ura_re
urase54624693ura_se
urate55432163ura_te
urbane82211383urban_e
urine55026603urin_e
ursae55214453ursa__e
ursine64114123ursin_e
usably11288983usably
usages759603usages
use36835163us___e
useable9911063useable
using66317963usin_g
usnea539393us_nea
usque14137733us_que
valance1269253valance
vane75534693_van_e
wane76344723_wan_e
whence14187923whence
wince105220883_wince
yince105214253_yince

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162946.00018786.0
3Display Results2942940.0933161.3
 (SQL Overall)1786912946.46927622.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.