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

99 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
precava144509(None) 
precavae1544811precavae
precaval1544721precaval
precast11314852precast
prepave14228872prepave
arcana8912583ar_cana
areca75618633arec__a
arecas84817453areca_s
brava106414793br__ava
breccia1344453breccia
greave104611493gre_ave
peavy135014843p_e_avy
pecan91919033p_eca_n
pecans101515833p_ecans
peccavi1643093peccavi
percale11314093percale
piasava1243883piasava
picara10311903p_icara
piccata1345703piccata
plectra1145793plectra
postcava15134033postcava
preach133613923pre_ach
preachy17307313preachy
preact103220393pre_act
preacts113211363preacts
preamp1238993pre_amp
preanal9310713pre_anal
prearm104512353pre_arm
preaver121011613pre_aver
prebade12310283prebade
prebake1539093prebake
prebasal1244723prebasal
precasts1239453precasts
precative16312573precative
precaudal1443413precaudal
precede1239653precede
precent113520263precent
precept133112513precept
precess11310863precess
precipe133012123precipe
precis103416703prec_is
precise113518173precise
preclean1245893preclean
preclear1245423preclear
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precrash1544823precrash
precure11312553precure
precut102016533prec_ut
precuts111710473precuts
predate10616893predate
predawn1335353predawn
predive13511083predive
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
pregame1239553pregame
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prela_w
premade12311443premade
preman104117453prema_n
prename11412643prename
prenatal1048373prenatal
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepaved16177233prepaved
prepaves15189193prepaves
prepay13310313prepa_y
prepays1437483prepays
prepupa1064023prepupa
prerace11414123prerace
presa74319043pre__sa
presage10312293presage
presale9416353presale
pretape113511623pretape
pretax152310193preta_x
prevail1238243prevail
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
procarp1346823procarp
reata54225393_re_ata
reave84528023_re_ave
recall83815733_recall
recane83022873_recane
recant83228683_recant
recap95718023_reca_p
recaps103615733_recaps
recast83422773_recast
recta74220263_rec_ta
regave104713383_regave
repave114813873_repave
trehala1045963trehala

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.403443402.0
2DLD Change Limit134027996.80019709.9
3Display Results99990.0303300.0
 (SQL Overall)178691997.23324705.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.