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

87 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
catwalk164532(None) 
catwalks1744791catwalks
cakewalk1643262cakewalk
catalo8314852cat_alo
catcall1139152catcall
catfall1237392catfall
cattalo938422cattalo
jaywalk2442522jaywalk
outwalk1437622outwalk
actual8311023actual_
attack12148153_attack
atwain937813_atwain
bytalk1533473byt_alk
cabal95222153ca_bal_
cabala103516913ca_bala
cabals104020153ca_bals
cabbala1367183cabbala
caecal103713733caecal_
cakewalks1742643cakewalks
calk105527663c___alk
calpack17338333calpack
canal75428043ca_nal_
canals84421663ca_nals
cantal84122033cantal_
cantala94114673cantala
cantals93919573cantals
canthal12410053canthal_
carack142113173ca_rack
carjack2246153carjack
carnal83919203carnal_
carpal103716253carpal_
carpale113414353carpale
carpals113414623carpals
carrack1548753carrack
carwash1535993carwash
casual81112863casual_
casuals91410523casuals
catalog1038003cat_alog
catalos9414163cat_alos
catalpa1136503cat_alpa
catawba1443703catawba
catcalls1238323catcalls
catchall1546233catchall
catclaw1443973catclaw
catface1436763catface
catfalls1347063catfalls
catjang1733923catjang
catnap1098383catna_p
catnaps1197033catnaps
cattail939183cattail
cattails1038553cattails
cattalos1037933cattalos
cattily123210853cattily
cattle85118903cat_tle
caudal91611483caudal_
caulk115315453ca__ulk
causal81413203causal_
causals91411183causals
chalk144814603c__halk
citral81113893citral_
citrals91111673citrals
coatrack1645853coatrack
cutback1747093cutback
cutbank1545533cutbank
cutwork16176813cutwork
fatal84819373fat_al_
fatback1836923fatback
fatwa1168063fatwa__
fatwas1249053fatwa_s
gadwall1244563gadwall
hatrack1638213hatrack
hawala12368913ha_wala
jaywalks2542143jaywalks
narwal938943narwal_
narwals1036983narwals
natal53921493nat_al_
outtalk1138233outtalk
outwalks1535993outwalks
racewalk1744063racewalk
ratal55025113rat_al_
ratals64219583rat_als
scatback1875033scatback
skywalk1642353skywalk
stalk94518003_st_alk
talk86230093__t_alk
uptalk1234653upt_alk
walk115625613___walk

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.1561145455.1
2DLD Change Limit134027876.20321606.8
3Display Results87870.0302900.0
 (SQL Overall)178691876.38927968.5
 
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.