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

133 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
currants103793(None) 
currans9310611curran_s
currant9314171currant_
currents1038371currents
courants10310802courants
currachs1544542currachs
curraghs1442882curraghs
curran8312022curran__
current9313692current_
errants7410642_errants
jurants14379212ju_rants
warrants1168502warrants
aberrants1145863aberrants
arrant6623253_arrant_
brants85723053__brants
burans85019303bu_ran_s
callants104112143callants
cants77036943c___ants
carats85929023c_ara_ts
carcanets1347313carcanets
carracks1637713carracks
carrots9714623carr_ots
cauterants1244713cauterants
chants115020393c__hants
cirrate92413493cirra_te
colorants1149863colorants
coolants1039943coolants
coranto9311893c_oranto
corantos10310103c_orantos
corbans11313173corban_s
cormorants1445343cormorants
corrades111211263corrades
corrals93713853corra_ls
corrects1259573corrects
corrupts1244983corrupts
corybants1644433corybants
courant9317973courant_
courante1049953courante
courantes1148883courantes
couranto1046903couranto
courantos1145793courantos
courlans10117613courlan_s
crafts115312743c__rafts
cranes84330753c__ranes
cranks125015313c__ranks
cuirass934973cuira_ss
cunts76125123cu___nts
curaghs1334583cu_raghs
curaras93911953cu_raras
curares94916853cu_rares
curarines11710553curarines
curaris94114773cu_raris
curate85226243cu_ra_te
curates95323833cu_rates
curbings13407313curbings
curets84922343cu_r_ets
curlings114110383curlings
curns74924283cu_r_n_s
currach1446453curra_ch
curragh1344293curra_gh
currajongs2051133currajongs
currency1545543currency
currently1445093currently
curriers103410753curriers
curries93723163curr_ies
curring103616843currin_g
currs75624393curr___s
curtails10318243curtails
curtains10259703curtains
curtals93111623curta_ls
curtate9312643curta_te
curvets12399913cu_rvets
cushats12288273cusha_ts
cutbanks1644313cutbanks
durians839573durian_s
durmasts1144093durmasts
durras74713373durra__s
entrants8311753entrants
errands847603_errands
errant6618733_errant_
formants13269953formants
furanes103214863fu_ranes
furans94515953fu_ran_s
furrings12317143furrings
grants73722473__grants
guaranas995943guaranas
guaranis996863guaranis
guaranty1244153guaranty
guardants1143793guardants
hurrahs13336773hurra_hs
hurrays13386153hurra_ys
hydrants1585793hydrants
intrants8312863intrants
jurant134216553ju_rant_
jurats134213203ju_ra_ts
kurgans12145653kurgan_s
lurdanes936063lurdanes
lurdans837073lurdan_s
marranos1038423marranos
migrants1138183migrants
mordants1137143mordants
murrains1036853murrains
murras84916013murra__s
mutants938583mu_tants
occurrents1453003occurrents
odorants946043odorants
operants1039483operants
ourangs8318503ou_rangs
outranks12298823outranks
puranas9712653pu_ranas
quadrants1965363quadrants
quants153614143qu__ants
rants55935343___rants
regrants9310013regrants
serranos857873serranos
servants1138003servants
spirants1088283spirants
subrents10310303subrents
surprints1145283surprints
surras65919533surra__s
terranes82514433terranes
titrants838483titrants
torrents838143torrents
truants738163_truants
turbans939563turban_s
turrets73010673turr_ets
tyrants1037453_tyrants
vagrants1246143vagrants
variants1139203variants
versants1137783versants
vibrants1345913vibrants
warrant10614243warrant_
warranty1465043warranty

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 Limit1461621337.39019778.3
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.85622745.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.