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

108 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
ableism113682(None) 
ableisms1245411ableisms
ableist9311771ableist
ableists1036542ableists
ables75935542able_s_
ablest84721832able_st
ageism968802a_geism
allelism1046972allelism
atheism1248522atheism
obelism1138202obelism
aaliis6312903aaliis_
abatis84317933abatis_
abbes96723523abbe_s_
abbess10509773abbe_ss
abbeys13538423abbeys_
abeam9316533ab_e_am
abeles84719393abeles_
abelia83114403abeli_a
abelian92810643abelian
abelias93213563abelias
abets75621673ab_ets_
able66340533able___
abled86926833able__d
abler75624313able__r
ablins8316193abl_ins
abloom1039783abl_oom
ablush1147223abl_ush
abolish12311503abolish
abreast9311273abreast
abris75722603ab_ris_
abscise1145953abscise
abseil837183absei_l
abseils935973abseils
abyes105518533abye_s_
abysm12598143ab__ysm
ageisms1056603a_geisms
ageist7315383a_geist
agism84614063a__gism
agleam9158623agle_am
aglets73915683aglets_
albeit8314343albei_t
albinism1276413albinism
alecs76620733a_lecs_
alefs87319663a_lefs_
ales47067103a_le_s_
alienism1047733alienism
alist56136783a_l_ist
allees64521483allees_
allelisms1156003allelisms
alleys95113303alleys_
allies63827673allies_
allium8311243a_llium
amblers115213563amblers_
ambles105121863amble_s_
animism113510213animism
arles56735743arle_s_
asterism10413253asterism
atavism1238033atavism
atheisms1346923atheisms
atheist10314063atheist
atomism112610963atomism
autecism1247073autecism
autism83815333a_utism
awless939263awle_ss
axles125219473axle_s_
baalism11310593baalism
baldish1339503baldish
balers85626933balers_
bales76250083bale_s_
baptism1337803baptism
blebs96416153_blebs_
blemish1436603_blemish
bless75917813_ble_ss
blest76431723_ble_st
blets75324943_blets_
bliss75616913_bl_iss
blueish1236483_blueish
bluish1159243_bluish
cabalism14310143cabalism
cablers114416713cablers_
cables104527553cable_s_
cablets114216343cablets_
casteism1247073casteism
cultism11158003cultism
deism84116033__deism
fablers124812613fablers_
fables114921673fable_s_
fideism1335773fideism
gables94222333gable_s_
holism113713753hol_ism
kabalism1647043kabalism
leis45739603__leis_
marbleise1343483marbleise
nabobism1444113nabobism
obelise9310173obelise
obelisk1345193obelisk
obelisms1236393obelisms
obiism1036363ob_iism
ogreism1044233ogreism
plenism11310113_plenism
poleis86018353poleis_
sablefish1742903sablefish
sables85026693sable_s_
seism75019023__seism
solecism12107593solecism
tables84524893table_s_
tablets94714383tablets_
theism1139483_theism

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.390458182.1
2DLD Change Limit1340271086.29621287.6
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.71626606.8
 
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.