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

54 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
insculp114379(None) 
insculps1243391insculps
incult82414772in_cult
inocula947262inocula
insculped1442702insculped
insoul638462insoul_
insouls737212insouls
insult62813672ins_ult
sculp95314842__sculp
bascule1136573bascule
ensoul638253ensoul_
ensouls736033ensouls
inclip1036823in_clip
incubi1035113in_cubi
incur72212253in_cu_r
incurs83012283in_curs
incus73315053in_cu_s
incuse83513573in_cuse
indult73614033in_dult
ingulf10310353in_gulf
inhaul936803inhaul_
inhauls1035523inhauls
inoculum1243443inoculum
inscape1138023inscape
inscroll10113213inscroll
insculping1542893insculping
insecure1044653insecure
insole63515863ins_ole
insouled936113insouled
instal6712193instal_
install779363install
instals7611713instals
instep838193ins_tep
instil61111383instil_
instill789063instill
instils7811453instils
insular7138703ins_ular
insulin738483ins_ulin
insults7268963ins_ults
insure63416603ins_ure
kingcup1642473kingcu_p
miniscule1343123miniscule
minuscule1342183minuscule
oscula837293_oscula
oscule838193_oscule
resculpt1245323resculpt
scalp95217983__scalp
sculk115112463__sculk
scull75315763__scull
sculps104611753__sculps
sculpt104412693__sculpt
scup84822383__scu_p
vascula1245853vascula
vincula1246393vin_cula

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 Filter1786911340270.420425454.8
2DLD Change Limit134027547.87617017.1
3Display Results54540.0163375.0
 (SQL Overall)178691548.31221498.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.