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

84 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
precava1445091precava
precast11314852precast
precavae1544812precavae
precaval1544722precaval
prefab1336242prefa_b
prepave14228872prepave
areca75618633areca__
arecas84817453areca_s
greave104611493gre_ave
peavy135014843p_e_avy
pecan91919033p_eca_n
pecans101515833p_ecans
peccavi1643093peccavi
percale11314093percale
preach133613923pre_ach
preachy17307313preachy
preact103220393pre_act
preacts113211363preacts
preamp1238993pre_amp
prearm104512353pre_arm
preaver121011613pre_aver
prebade12310283prebade
prebake1539093prebake
precasts1239453precasts
precative16312573precative
precede1239653precede
precent113520263precent
precept133112513precept
precess11310863precess
precipe133012123precipe
precis103416703prec_is
precise113518173precise
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precrash1544823precrash
precure11312553precure
precut102016533prec_ut
precuts111710473precuts
predate10616893predate
predawn1335353predawn
predive13511083predive
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
pregame1239553pregame
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prela_w
premade12311443premade
preman104117453prema_n
prename11412643prename
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepaved16177233prepaved
prepaves15189193prepaves
prepay13310313prepa_y
prepays1437483prepays
prerace11414123prerace
presa74319043presa__
presage10312293presage
presale9416353presale
pretape113511623pretape
pretax152310193preta_x
prevail1238243prevail
preverb14317063preverb
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
procarp1346823procarp
reave84528023_re_ave
recall83815733_recall
recane83022873_recane
recant83228683_recant
recap95718023_reca_p
recaps103615733_recaps
recast83422773_recast
recomb1238873_recomb
regave104713383_regave
rehab10312443_reha_b
repave114813873_repave

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 Limit134027846.70619986.1
3Display Results84840.0136461.5
 (SQL Overall)178691847.12225090.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.