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

136 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
fallacy153643(None) 
allay85620392_alla_y
fallal93612692falla_l
fallals103310192fallals
fallaway1743902fallaway
fallback1944552fallback
wallaby1535072wallaby
abbacy1536623_abbacy
alack114820063_a_lack
alary86123443_a_lary
allays94313743_allays
alley85721673_all_ey
alloy85519973_all_oy
ally76935643_all__y
alpaca1047383_alpaca
alway116113923_alwa_y
anlace82513923_anlace
ballad94315323balla_d
ballade104012563ballade
balladry1444213balladry
ballads104212913ballads
ballast9313993ballast
ballsy11508873ball_sy
bally105530103ball__y
bullace113410673bullace
calla74827073calla__
callan83619603calla_n
callans94518473callans
callant94121223callant
callas84526753calla_s
callback1845333callback
callboy1465833callboy
calpac123211063calpac_
calpack17338333calpack
calpacs133110343calpacs
calvary1537183calvary
cullay113910173culla_y
dally95324743dall__y
falbala1235873falbala
falcate12311613falcate
fall75535313fall___
fallacies1446833fallacies
fallalery1542173fallalery
fallaways1843163fallaways
fallbacks2044353fallbacks
fallen93813373fall_en
faller94621233fall_er
fallers103917993fallers
fallibly1644393fallibly
falling113621583falling
falloff1245953falloff
fallout10313503fallout
fallow124713853fall_ow
fallows133713973fallows
falls85727653fall__s
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
fancy134615483fa__ncy
fantasy1336153fantasy
farcy135217093fa__rcy
fatally1339893fatally
fatback1836923fatback
fatly115716803fatl__y
faulty12429363faul_ty
fella84918653fella__
fellah124910773fella_h
fellahs13428393fellahs
fellas95116963fella_s
fellate10313433fellate
felly114922803fell__y
filly114424903fill__y
flack144519413f__lack
flaky155715583f__laky
flamy135217473f__lamy
flawy145913383f__lawy
flaxy189012293f__laxy
flay106332803f__la_y
fleecy14266483f_leecy
floaty124210943f_loaty
folly115022603foll__y
fullam1138363fulla_m
fullams1236553fullams
fullback1943853fullback
fullery13337973fullery
fullface1642553fullface
fully114820863full__y
galaxy17476313ga_laxy
gallant83517113gallant
gallate83417123gallate
gallery11468743gallery
galley104215453gall_ey
gallfly1433523gallfly
gallic9411643gallic_
gallica1047463gallica
gally95026173gall__y
galyac1235973galyac_
galyacs1335273galyacs
hallah124115403halla_h
hallahs133912463hallahs
hallal94415563halla_l
hallway1636173hallway
kalpac14428223kalpac_
kalpacs15327133kalpacs
lacy95829633___lacy
lallan63414173lalla_n
lalland83810183lalland
lallans74113533lallans
lullaby1243363lullaby
malady1237863ma_lady
mallard10310273mallard
palace104516913pa_lace
pally105727123pall__y
palmary14338553palmary
papacy1547493pa_pacy
parlay113713993parla_y
pollack1567333pollack
prelacy1437583prelacy
rally84725903rall__y
salary9515213sa_lary
sallowy13369343sallowy
sally85129713sall__y
tallage82712073tallage
tallboy1265143tallboy
tallowy13347633tallowy
tally84526863tall__y
valency1565463valency
valiancy1674813valiancy
vallate103016563vallate
valley124311603vall_ey
walla85321033walla__
wallah124011993walla_h
wallahs13409473wallahs
wallas95719393walla_s
wally114625093wall__y
waylay1535453wayla_y

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.1561145455.1
2DLD Change Limit1340271367.11018850.5
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.31224438.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.