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

120 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
psywar144332(None) 
psywars1533671psywars
phylar14437372phylar
postwar1236902postwar
prewar114712582prewar
prowar114110942prowar
sewar85421102_sewar
sowar85821342_sowar
anyway1534803anyway
ashlar9338193ashlar
astylar10265063astylar
aswarm11107913as_warm
asyla839333asyla_
boyar106013763boy_ar
byway1647533_byway
cymar125711263_cymar
dewar95817733_dewar
escar74011993es_car
eschar1136533eschar
eskar9457453es_kar
flyway18134693flyway
gaydar1135503gaydar
hayward1736413hayward
isobar836143isobar
jowar155211433_jowar
keyway1943823keyway
kyar116916843_ky_ar
mylar105311533_mylar
nonwar9159423nonwar
osar46820953os__ar
outwar91011513outwar
palmar104113463palmar
par57467023p___ar
pawer104422973p_awer
paxwax1742953paxwax
payday1536613payday
payer105125723pay_er
payor105413843pay_or
pear69745233p__ear
pedlar93311273pedlar
pesewa1135543pesewa_
pesewas1236223pesewas
phyla13469183phyla_
phylae14458733phylae
pilar75221503p_ilar
pillar8314023pillar
planar84212713planar
playwear1642103playwear
plower114315063plower
plyer106214333ply_er
polar75623453p_olar
poplar103611113poplar
power105325953p_ower
prewarm14479613prewarm
prewarn124410153prewarn
prower114218123prower
pryer104415313pry_er
pshaw13447513ps_haw
pshaws14435703pshaws
psoae74411623ps_oae
psoai7469923ps_oai
psoas75012983ps_oas
psych1554963psy_ch
psyche1674293psyche
psycho1674533psycho
psychs1653653psychs
psylla1133953psylla
psyllas1244883psyllas
psyops1334343psyops
pulsar8329363pulsar
pya87023753p_y_a_
pyas96225703p_y_as
pyran10514473p_yran
sawer85026213_sawer
scar66434203_s_car
sear47353843_s_ear
sewan85921293_sewan
sewars94018633_sewars
sewer84426223_sewer
shear85424833_shear
shwa106014963_shwa_
shwas116415103_shwas
simar74920813_simar
sitar54820543_sitar
sizar145214993_sizar
skyward1843863skyward
skyway1933343skyway
smear74416393_smear
soar46838673_s_oar
sofar86115493_sofar
solar55927343_solar
sonar56523423_sonar
sowars94318013_sowars
sowcar1135863_sowcar
sower85229313_sower
spar65433303_s_par
spear75821063_spear
spewer115112153spewer
star48037763_s_tar
stylar9358113stylar
sugar6312913_sugar
swab96825313_s_wab
swag87526733_s_wag
swam96329983_s_wam
swan76631313_s_wan
swap95925433_s_wap
sward94221463_s_ward
sware85828213_s_ware
swarf115324653_s_warf
swarm106218843_s_warm
swart86234643_s_wart
swat77244443_s_wat
sway107128233_s_way
swear85316853_swear
tsar47819803ts__ar
upsoar8105683ups_oar
war67262423___war
wayward1736053wayward
yar67253833__y_ar
year76534253__year

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 Filter1786911127160.393454684.5
2DLD Change Limit1127161206.25018034.6
3Display Results1201200.0602000.0
 (SQL Overall)1786911206.70326658.4
 
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.