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

191 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
christy153662(None) 
charity15311022chari_ty
chesty144610502ch_esty
chitty14329432ch_itty
chrism13710672chris_m
chrisma1456822chrisma
chrisms1499142chrisms
chrisom1466622chrisom
christen13106702christen
christie1347782christie
crispy13478562c_rispy
crista8311802c_rista
crusty114911342c_rusty
thirsty1354082thirsty
thrifty1634192thrifty
wristy12509702_wristy
aorist64827873aorist_
aorists74215833aorists
arista6415293_arista
aristo6414033_aristo
aurist65027253aurist_
aurists74615783aurists
barista9310813barista
bheesty1542493bheesty
bristly12178063_bristly
cariosity1446213cariosity
carroty1248943carroty
cavity14310013cavi_ty
cecity1398153ceci_ty
cerise84822043ceris_e
cerises94722253cerises
cerite84724873ceri_te
chais107530313chais__
chaise114916413chais_e
chaises124317493chaises
chanty145215823ch_anty
chariest13315513chariest_
charily15310283chari_ly
chariot12316213chariot_
chariots1339393chariots
charism14712203charis_m
charisma1576363charisma
charisms15710263charisms
chartist131112133chartist_
chartists14126803chartists
chasmy16468543ch_asmy
chaste114617393ch_aste
chatty14419363ch_atty
cheesy14419193chees_y
chemist143615003chemist_
chemistry1944433chemistry
chemists152710323chemists
cherish15310463cheris_h
cherty144612473ch_erty
chest104926143ch_est_
chests114916263ch_ests
chicly16429203ch_icly
chilly144113223ch_illy
chinky185610543ch_inky
chints115117833ch_ints
chintz204212033ch_intz
chintzy24364223ch_intzy
chippy18437613ch_ippy
chirpy16498913ch_irpy
chis95933313ch_is__
chisel112111943ch_isel
chit96937463ch_i_t_
chits105424573ch_i_ts
chivvy20374433ch_ivvy
chivy164810363ch_i_vy
choosey15459233choosey
choosy14459103choos_y
chorister1487153chorister
chrismal1575173chrismal
chrismon1544643chrismon
chrisoms1566093chrisoms
christens14125423christens
christies1449273christies
chromy16309903chr_omy
chutist1239453chutist_
chutists1335583chutists
chymist17268173chymist_
chymists18285603chymists
cissy104811073c__issy
cist67244963c__ist_
cists76624533c__ists
city95122623c__i_ty
clarity12310913clari_ty
clerisy1246823cleris_y
comity13312713comi_ty
crafty14478913c_rafty
cressy11439113c_ressy
crest74632693c_rest_
crests85218703c_rests
crikey15317783c_rikey
crimpy15489393c_rimpy
cris66233433c_ris__
crises84529433c_rises
crisic103611843c_risic
crisis83716343c_risis
crisp95014623c_ris_p
crisply14426523c_risply
crisps104411513c_risps
crissa837623c_rissa
cristae9310613c_ristae
crit65743713c_ri_t_
crits75527573c_ri_ts
crust75827663c_rust_
crusts84916543c_rusts
cubist104214443cubist_
cubists11359023cubists
curiosity1444543curiosity
curite85222943curi_te
curst74931023cur_st_
curtsey1255013curtsey
curtsy1156643curts_y
czarist18710223czarist_
czarists1966223czarists
drifty13418223_drifty
feisty12449293_feisty
ferity122813343feri_ty
frisky16406673_frisky
frosty124710633_frosty
ghosty13467213gh_osty
grisly104310583_grisly
grist65529873_grist_
gristly11187333_gristly
grists74716483_grists
gritty10338403_gritty
hasty115718763_h_asty
heist87030913_heist_
heists96814633_heists
hissy116112123_h_issy
hist76551543_h_ist_
hists86328373_h_ists
hoist86433213_hoist_
hoists95516023_hoists
jurist134616393jurist_
jurists14409123jurists
lyrist9312293lyrist_
lyrists1036963lyrists
misty106120453__misty
parity114719873pari_ty
prissy11347853_prissy
purist85525053purist_
purists94014073purists
purity114114913puri_ty
rarity93615493rari_ty
risky126311523__risky
rusty85221053__rusty
sacristy1345103sacristy
schist11312653sch_ist_
schists1248543sch_ists
shifty15409263sh_ifty
shirty124312563sh_irty
shist84829613sh_ist_
shists96515113sh_ists
shitty124110063sh_itty
shrieky17364803shrieky
shrift12413543shrift_
shrifts1335963shrifts
shrilly13318563shrilly
shrimpy17415403shrimpy
shris84221453shris__
theist9314763theist_
theists1039153theists
thirst9312253thirst_
thirsts1036243thirsts
thirty12378403th_irty
thistly1395963th_istly
thrift12412043thrift_
thrifts1335523thrifts
throaty13428483throaty
thrust91911893thrust_
thrusts10226523thrusts
touristy1144513touristy
triste63818643_triste
trusty94710113_trusty
turista737443turista
twisty12426863_twisty
variety1337743variety
varsity1356673varsity
verist93823893verist_
verists103613673verists
verity123714853veri_ty
whisky19455903wh_isky
whist115322953wh_ist_
whists124613813wh_ists
whity145513473wh_i_ty
wrist84827563_wrist_
wrists95415643_wrists

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 Limit1340271915.89022755.0
3Display Results1911910.0802387.5
 (SQL Overall)1786911916.37628025.6
 
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.