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

115 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
ableists103654(None) 
ableisms1245411ableisms
ableist9311771ableist_
ableism1136822ableis_m
ablest84721832able_st_
ageists848492a_geists
atheists1138712atheists
abatises10311013abatises
abbess10509773abbe_s_s
abbesses1235333abbesses
abelias93213563abeli_as
abets75621673ab_e__ts
ablauts936083abl_auts
ablegate1147253ablegate
ablegates1246793ablegates
ables75935543able___s
ablings1038743abl_ings
ablins8316193abl_i_ns
abluents1045463abluents
abreacts1245633abreacts
abreast9311273abreast_
abscises1246233abscises
abseils935973absei_ls
absents93510723abse_nts
ageisms1056603a_geisms
ageist7315383a_geist_
agists75713173a__gists
aglets73915683agle__ts
agonists9289833agonists
albeit8314343albei_t_
alerts64418223a_le_rts
alienists946913alienists
alist56136783a_l_ist_
allelisms1156003allelisms
allergists1144213allergists
altoists848753altoists
amorists10411333amorists
animists103010633animists
aorists74215833a_orists
arbalests1144123arbale_sts
arbalists1148483arbalists
arbelests1143653arbelests
arborists1147453arborists
arrests73312683arre_sts
artists74215593a_rtists
assists738473a_ssists
atavists1137583atavists
atheisms1346923atheisms
atheist10314063atheist_
atomists102610963atomists
attests7278813atte_sts
aurists74615783a_urists
autists73814853a_utists
awless939263awle_s_s
ballasts1037933ballasts
ballista1045803ballista
baptists1236723baptists
bassists1037183bassists
beasts84519723_b_easts
bemists113410703_bemists
bests75932613_b_e_sts
biblists1236873bibl_ists
blasts85116773_bl_asts
bleats85518613_ble_ats
bless75917813_ble_s_s
blesses93812393_blesses
blest76431723_ble_st_
blets75324943_ble__ts
bliss75616913_bl_is_s
breasts939703_breasts
cabalists1339153cabalists
cablecasts1652283cablecasts
cablets114216343cable__ts
canoeists1147163canoeists
cellists1038563cellists
cultists10107633cultists
deists74916433__deists
delists84414173del_ists
duelists966003duelists
elegists9128113_elegists
enlists749393enl_ists
epeeists1044793epeeists
fabulists1444723fabulists
feists94915313__feists
fideists1245543fideists
gabfests1442383gabfe_sts
heists96814633__heists
holists104413963hol_ists
hygeists1543543hygeists
kabalists1546293kabalists
leasts64616413__leasts
legists899593__legists
libelists1146953libelists
lists56628693__l_ists
marbleises1443523marbleises
molests93311563mole_sts
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
oblasts947303obl_asts
oboists937903ob_oists
obtests9136233obte_sts
palmists12268813palmists
panelists1148343panelists
plenists1038253_plenists
polemists1348603polemists
pollists10910823pollists
poloists10910523poloists
rallyists1243333rallyists
relists73817053rel_ists
solecists1187073solecists
soloists869153soloists
tablets94714383table__ts
teleosts846423teleosts
theists1039153_theists

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.423422437.4
2DLD Change Limit1461621157.90618487.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.37521336.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.