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

115 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
catfaces153696(None) 
catface1436761catface_
carfares13310322carfares
catfalls1347062catfalls
outfaces132311392outfaces
actuates10310313actuates
anlaces92313733_anlaces
atlases72410643_atlases
attaches13137723_attaches
attacks13126943_attacks
bifaces1448063_bifaces
cabbages1537203cabbages
caddices14297853caddices
cadences1338473cadences
cafes106426923ca_f__es
caftaned1445093caftaned
caftans12179443cafta_ns
calces104420053ca__lces
calices114321693ca_lices
califates14310113califates
calpacks18266523calpacks
calpacs133110343calpac_s
calyces14428803ca_lyces
camases114216343ca_mases
canapes111213083ca_napes
canvases13349523canvases
capiases1239253capiases
caprices1439893caprices
caracks152211563ca_racks
carafes125015703ca_rafes
carapaces1546053carapaces
carates95630613ca_rates
carcases12313093carcases
carfare12310073carfare_
carices114220953ca_rices
carjacks2345573carjacks
carnages11312213carnages
caroaches1637793caroaches
carracks1637713carracks
cartages11313313cartages
cascades13128553cascades
caseases10410473caseases
caseates10313713caseates
castrates11312673castrates
catalases1149443catalases
cataloes10311653cataloes
catalos9414163cat_alos
cataracts1345583cataracts
catcalls1238323catcalls
catches144320773cat_ches
catenates11311813catenates
cates75951893cat___es
catfacing1744553catfacing
catfacings1842183catfacings
catfall1237393catfa_ll
catfishes1746303catfishes
catharses1446413catharses
cathects1545793cathects
cathexes2036273cathexes
cathodes1439393cathodes
catjangs1843223catjangs
catnaper1294933catnaper
catnapers1364763catnapers
catnaps1197033catna_ps
cattails1038553cattails
cattaloes1146183cattaloes
cattalos1037933cattalos
catties94023053cat_ties
catwalks1744793catwalks
caudates11310263caudates
caudices13337343caudices
caviares1337993caviares
cetanes9315133cet_anes
citrates102315093citrates
clubfaces1841913clubfaces
coatracks1745403coatracks
cottages113310493cottages
cutbacks1845813cutbacks
cutlases1038033cutlases
cuttages11297223cuttages
defaces133213403_defaces
dogfaces1554143dogfaces
effaces15277273_effaces
enfaces122110913_enfaces
faces106439433___faces
fanfares1436773fanfares
fatbacks1946003fatbacks
hatracks1737533hatracks
latices9313763lat_ices
lattices1038383lattices
matrices12312083matrices
oatcakes1445543oatcakes
outface123011973outface_
outfaced14219463outfaced
outpaces122411943outpaces
outraces102217863outraces
palaces114216463pa_laces
palefaces1645303palefaces
patacas11311003pat_acas
postfaces1656273postfaces
prefaces15311063prefaces
ratafees1144143ratafees
refaces123216743_refaces
retraces101417273retraces
satiates8314633satiates
scatbacks1974713scatbacks
surfaces1338673surfaces
taces76237803__t_aces
traces85329933__traces
unifaces1346393unifaces
waftages15105393waftages
warfares1436683warfares
watapes12228383wat_apes
wattages12106783wattages
wattapes1395253wattapes

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621157.73318901.1
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.20221786.3
 
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.