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 “ableisms” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
ableisms124541(None) 
ableism1136821ableism_
ableists1036541ableists
ableist9311772ableis_t
ageisms1056602a_geisms
allelisms1156002allelisms
atheisms1346922atheisms
obelisms1236392obelisms
abatises10311013abatises
abbess10509773abbe_s_s
abbesses1235333abbesses
abelias93213563abeli_as
ables75935543able___s
ablest84721833able_s_t
ablings1038743abl_ings
ablins8316193abl_i_ns
abscises1246233abscises
abseils935973absei_ls
abysms13565653ab__ysms
ageism968803a_geism_
ageists848493a_geists
agisms9399393a__gisms
albinisms1395773albinisms
alienisms1146703alienisms
allelism1046973allelism_
alliums957973a_lliums
animisms12328393animisms
asterisms11511063asterisms
atavisms1346993atavisms
atheism1248523atheism_
atheists1138713atheists
atomisms12269573atomisms
autecisms1346033autecisms
autisms94311553a_utisms
awless939263awle_s_s
baalisms1238033baalisms
baptisms1446033baptisms
bless75917813_ble_s_s
blesses93812393_blesses
bliss75616913_bl_is_s
cabalisms1548433cabalisms
casteisms1345253casteisms
cultisms12126713cultisms
deisms94411043__deisms
fideisms1444453fideisms
holisms123811113hol_isms
kabalisms1745953kabalisms
marbleises1443523marbleises
nabobisms1543693nabobisms
obelises1039103obelises
obelisks1443443obelisks
obelism1138203obelism_
obiisms1135673ob_iisms
ogreisms1144113ogreisms
plenisms1237963_plenisms
seisms84912143__seisms
solecisms1396703solecisms
theisms1237763_theisms

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.1531167915.0
2DLD Change Limit146162587.97018339.0
3Display Results58580.0331757.6
 (SQL Overall)178691588.15621909.1
 
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.