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

141 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
harpists133810(None) 
harpist12312351harpist_
artists74215592_artists
chartists14126802chartists
harpies123818312harpi_es
harpings14379772harpings
harpins123615702harpi_ns
harvests14246172harvests
hornists11208832hornists
narcists1078112narcists
papists112110452pa_pists
rapists92510752ra_pists
ageists848493_ageists
agists75713173_a_gists
airposts1045923airposts
alarmists1145943alarmists
aorists74215833_aorists
arises65233803_ar_ises
arista6415293_ar_ista
aristas7413523_ar_istas
aristo6414033_ar_isto
aristos7312373_ar_istos
armpits1157133_armpi_ts
aroints7313133_aroints
arpents93613083_arpents
arrests73312683_arrests
arrises71617583_arrises
artist64125543_artist_
artiste73813693_artiste
artistes83213343_artistes
aspises9611643_aspises
assists738473_assists
aurists74615783_aurists
autists73814853_autists
baptists1236723baptists
barista9310813bar_ista
baristas1039723bar_istas
bassists1037183bassists
cambists1437023cambists
carpets113915333carp_ets
carpings133812383carpings
carports1238943carports
casuists1036523casuists
chariots1339393char_iots
charisms15710263char_isms
chartist131112133chartist_
czarists1966223czar_ists
dadaists1045583dadaists
diarists9410363diar_ists
earnests837853earnests
faddists13235543faddists
fascists1336613fascists
fauvists1443843fauvists
garpikes1534373garpikes
grists74716483_gr_ists
habits113014653ha_bi_ts
haffits1636193haffi_ts
hagadists1445073hagadists
haggises1335883haggises
haints94417583ha__ints
hairpins1365433hairpi_ns
halakists16125353halakists
handlists1347133handlists
happiest152411673happiest_
harass9313943har_as_s
harasses11311033harasses
hardass1139753hardas_s
hardest113118413hardest_
hardhats1546833hardhats
hardies114923233hardi_es
hardiest123416333hardiest_
haricots1347333haricots
harissa1035503har_issa
harissas1145983harissas
harlots103413293har_lots
harmines132715143harmines
harmins123716723harmi_ns
harmonists15137123harmonists
harness102413933harnes_s
harpers124916203harp_ers
harpin113614383harpi__n
harping134118383harpi_ng
harpoons1337483harpoons
harps105926873harp___s
harriers113712433harriers
harries103525493harri_es
harslets1137833harslets
harts88441593har___ts
harvest132112753harvest_
hatpins123410643hatpi_ns
heists96814633h__eists
heriots10312063her_iots
hermits12312143hermi_ts
heroisms1338693heroisms
hists86328373h___ists
hoists95516023h__oists
holists104413963h_olists
hornist102314823hornist_
horsts95817513hor__sts
hursts97213093hur__sts
hygeists1543543hygeists
hymnists1644903hymnists
jurists14409123jur_ists
karsts106012943kar__sts
lapises93513463la_pises
lariats7615053lar_iats
lyrists1036963lyr_ists
maists85817573ma__ists
marplots1245633marplots
narcisms1267263narcisms
narcist9512443narcist_
oralists8611803oralists
palmists12268813palmists
papisms13238543pa_pisms
papist102618743pa_pist_
parises94827183par_ises
parodists1248513parodists
parvises133911913parvises
persists1049183persists
phallists1445723phallists
purists94014073pur_ists
racists92613323ra_cists
rapist82520673ra_pist_
sacrists1039563sacrists
sadists83310853sa_dists
sapphists1644103sapphists
sarodists1056593sarodists
sharpest1339143sharpest_
sharpies13411223sharpi_es
tachists1348183tachists
tanists7313653ta_nists
tapises92914013ta_pises
therapists1544403therapists
tsarists857303tsar_ists
typists1236173_typists
tzarists1755693tzar_ists
utopists1045773utopists
varmints1335643varmints
verists103613673ver_ists
waists97415453wa__ists
wrists95415643_wr_ists

Search took 9 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 Limit1461621418.09618053.6
3Display Results1411410.0602350.0
 (SQL Overall)1786911418.57620836.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.