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

188 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
courants1031080(None) 
courant9317971courant_
courante1049951courante
courantes1148881courantes
couranto1046901couranto
courantos1145791courantos
colorants1149862colorants
coolants1039942coolants
coranto9311892co_ranto
corantos10310102co_rantos
counts84618272cou__nts
courages11311392courages
courantoes1244032courantoes
courlans10117612courlan_s
courts84216172cour__ts
currants1037932currants
jurants14379212_jurants
ourangs8318502_ourangs
accusants1344283accusants
anurans73810553anuran_s
boranes93720403bo_ranes
bouffants1742133bouffants
bournes93615023bour_nes
bourns84114063bour_n_s
brants85723053__brants
burans85019303_buran_s
callants104112143callants
cants77036943c___ants
carats85929023c_ara_ts
cauterants1244713cauterants
chants115020393c__hants
churns114910233chur_n_s
coacts105314333co__acts
coagents1138453coagents
coagulants1343333coagulants
coapts104614013co__apts
coasts85719143co__asts
coats75635003co__a_ts
cobalts1139203co_balts
cobras104014193cobra__s
cocoanuts1343193cocoanuts
coenacts1246403coenacts
coerects1258543coerects
colorant10414723colorant_
combats13311683comba_ts
commands15318823commands
comments142913883comments
compacts16368903compacts
comparts144210833comparts
comrades13149773comrades
concents122516603concents
confronts1447063confronts
congrats11311433congra_ts
conjugants2043363conjugants
consents102715893consents
constants11410913constants
contacts123215213contacts
contents104018213contents
contracts132212013contracts
contrasts112211043contrasts
convents132614603convents
coolant9316463coolant_
coparents1347973coparents
coprahs14338153copra_hs
copras103517153copra__s
corals85325143co_ra_ls
corantoes1147653co_rantoes
corbans11313173corban_s
cormorants1445343cormorants
cornets94820573co_rnets
corns76034763co_r_n_s
cornus84816563co_r_nus
coronas93916913co_ronas
coronets103814363co_ronets
corrades111211263corrades
corrals93713853corra_ls
corrects1259573corrects
corrupts1244983corrupts
corsets94819803co_rsets
corvets124715023co_rvets
corybants1644433corybants
cosecants1346533cosecants
cotans81317923co_tan_s
cotenants1147283cotenants
couchant1549053couchant_
cougars1038443couga_rs
count74932053cou__nt_
county114313323cou__nty
couplets12389873couplets
coupons112710563coupon_s
courage10310993coura_ge
couriers103213173couriers
courlan9117763courlan__
coursers104412303coursers
courses94218893cour_ses
coursings12235873coursings
court75532773cour__t_
courters103015373courters
cousins9516003cousin_s
couvades1435613couvades
covenants1445893covenants
cowbanes1537423cowbanes
cowhands1765263cowhands
cowpats1437713cowpa_ts
crafts115312743c__rafts
cranes84330753c__ranes
cranks125015313c__ranks
cunts76125123c_u__nts
curaghs1334583c_uraghs
curaras93911953c_uraras
curares94916853c_urares
curaris94114773c_uraris
curate85226243c_ura_te
curates95323833c_urates
curets84922343c_ur_ets
curns74924283c_ur_n_s
currans9310613curran_s
currant9314173currant_
currents1038373currents
curvets12399913c_urvets
dopants1038433do_pants
dourahs11487253doura_hs
douras75016723doura__s
dourines9311373dourines
eluants737583elu_ants
entrants8311753entrants
errants7410643_errants
figurants1343973figurants
fondants1246203fondants
forints10411833fo_rints
formants13269953formants
founts94313383fou__nts
furanes103214863_furanes
furans94515953_furan_s
gouramis1184163gouramis
gourmands1343313gourmands
gourmets1144153gourmets
grants73722473__grants
hydrants1585793hydrants
insurants947653insurants
intrants8312863intrants
journals1574353journals
journos14134943jour_nos
jurant134216553_jurant_
jurats134213203_jura_ts
korats105416063ko_ra_ts
lorans65117603lo_ran_s
migrants1138183migrants
mordants1137143mordants
mounts84115073mou__nts
mourns84111013mour_n_s
mutants938583_mutants
nougats8427413nouga_ts
occupants1543053occupants
octants9128733_octants
odorants946043odorants
operants1039483operants
orangs74116033_o_rangs
ourang73311063_ouran_g
ouraris73512933_ouraris
outacts9310213_outacts
outranks12298823_outranks
puranas9712643_puranas
quants153614143_qu_ants
rants55935343___rants
regrants9310013regrants
roborants1145053roborants
saturants946383saturants
scourings12235293scourings
sonants7511233so_nants
sonorants947083sonorants
sopranos1046433sopranos
soudans8309353soudan_s
soutanes8312933soutanes
sovrans1036483sovran_s
sovranty1443463sovranty
spirants1088283spirants
titrants838483titrants
torrents838143torrents
toucans937583toucan_s
touracos1045313touracos
tourings9277373tourings
tourists838313tourists
truants738163tru_ants
tyrants1037453_tyrants
vagrants1246143vagrants
vibrants1345913vibrants
warrants1168503warrants

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621886.65621959.4
3Display Results1881880.0632984.1
 (SQL Overall)1786911887.13925030.3
 
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.