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 “ahimsas” 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
ahimsas123478(None) 
ahimsa1134781ahimsa_
animas84418722anim_as
chimlas1437452chimlas
shiksas1484642shiksas
abioses9311493abioses
abiosis939373abiosis
abomas101113583abom_as
admass957143a_dmass
aftosas10147153aftosas
agamas97413453agam_as
agisms9399393agi_sms
agists75713173agi_sts
agitas7310593agi_tas
agmas85919873a_gm_as
ahis76135383ahi___s
aimers84621913a_imers
aims67738183a_im__s
ajivas1655133aji_vas
alias55834603ali__as
aliases7914493aliases
aliyas93911803ali_yas
almas76629773a_lm_as
amas67746293a__m_as
amass77119683a__mass
amias75831473a__mias
amigas95912173ami_gas
amiss75823073ami_s_s
anemias92512143anemias
anhingas12104333anhingas
anima74620073anim_a_
animal85016253anim_al
animals94111703animals
animes84719593anim_es
animis84615943anim_is
animisms12328393animisms
animists103010633animists
animus84211613anim_us
animuses1037983animuses
anises64826693ani_ses
arias55438023ari__as
ariosos7409853ariosos
arises65233803ari_ses
aristas7413523aristas
aromas81018613arom_as
atmas75721013a_tm_as
avisos95410483avi_sos
axillas14278963axillas
axises134413993axi_ses
bimas95521743_bim_as
camisas113411923cami_sas
chamisas15317813chamisas
chias104625523chi__as
chiasmas15306593chiasmas
chiasms14357523chiasms
chicas135916473chi_cas
chimar133911473chim_ar
chimars144010593chimars
chimbs153910303chim_bs
chimeras15388833chimeras
chimers144515143chimers
chimes134922573chim_es
chimla1337593chimla_
chimps155713663chim_ps
chinas115119403chi_nas
dipsas9359893_dipsas
halmas117017893halm_as
hamzas20119013_hamzas
hansas94616043_hansas
harissas1145983harissas
hijras1635773_hijras
hims95230973_him__s
hiss75629213_hi_s_s
hisses94719353_hisses
hists86328373_hi_sts
kalimbas1642323kalimbas
limas75627633_lim_as
limbas105313203_limbas
limpas105513083_limpas
marimbas1444363marimbas
mimosas1136753_mimosas
ohias84415573ohi__as
paisas84317493pai_sas
phimoses1537203phimoses
phimosis1546193phimosis
pimas94725103_pim_as
primas104418103prim_as
rhumbas14305163rhumbas
shamas113717943sham_as
shammas14358723shammas
shicksas1743523shicksas
shiksa1394653shiksa_
shikses14116573shikses
shims104422553shim__s
shists96515113shi_sts
shivas124512413shi_vas
simas75727553_sim_as
thirsts1036243thirsts
visas84317653_vi_sas
whims134515333whim__s
whimsey18373893whimsey
whimseys19322463whimseys
whimsies1635193whimsies
whimsy17375223whims_y
whipsaw1842723whipsaw
whipsaws1942693whipsaws
whisks16497353whi_sks
whists124613813whi_sts

Search took 8 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 Limit1340271087.18618651.1
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.63823395.0
 
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.