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

85 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
prussic114474(None) 
poussie936622poussie
prosaic11311162prosaic
prossie91812962prossie
rustic8712672_rustic
arkosic1346063arkosic
brassica1244873brassica
brassie93411523brassie
bustic101012693_bustic
caustic1139753caustic
classic113710113classic
crisic103611843cr_isic
drastic10310883drastic
druidic1143533druidic
eristic9814093eristic
fustic11910633_fustic
grushie1135813grushie
gussie72910153_gussie
jurassic1742993jurassic
music94316403_mu_sic
neustic937943neustic
passim10410283p_assim
pertussis1143323pertussis
phasic133612053p_hasic
physic16288473p_hysic
plasmic13249113plasmic
plastic112815063plastic
plumbic1543963plumbic
plusses93510693plusses
potassic1244923potassic
poussies1038113poussies
practic13312253practic
preship1439793preship
preslice1258623preslice
press75425953press__
pressed103317313pressed
presser93717623presser
presses93523153presses
pressing112516443pressing
pressor93512883pressor
priapic1346023priapic
primsie1137543primsie
priss74623893priss__
prissed103311263prissed
prisses94816713prisses
prissier10157873prissier
prissies101712003prissies
prissily1346693prissily
prissing113011453prissing
prissy11347853priss_y
prosit85124593pr_osit
prosodic1347693prosodic
pross76529403pross__
prosses94019513prosses
prossies101515233prossies
prostie91617743prostie
prudish1376563prudish
pruritic1267403pruritic
prussiate1144523prussiate
pubic114513723p_u_bic
public12238143p_ublic
pudic104614563p_u_dic
puranic11410483puranic
puristic1239383puristic
pursuit948273pursuit
puss64830133p_uss__
pusses84322843p_usses
pussier93711993p_ussier
pussies93615693p_ussies
pussly11407373p_ussly
pussy105614843p_uss_y
rubric1097823_rubric
runic73615773_ru_nic
russet6319433_russet
russify1334063_russify
rustics9810733_rustics
triassic1044633triassic
trismic1137483trismic
truistic1046903truistic
truss54916923truss__
trussed84010033trussed
trusser74010263trusser
trusses73813643trusses
trussing9268653trussing
tussis6379953_tussis

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.423422437.4
2DLD Change Limit134027857.56317721.4
3Display Results85850.0302833.3
 (SQL Overall)178691858.01622291.8
 
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.