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

88 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
perturb114600(None) 
perturbs1244361perturbs
aperture1046382aperture
perdure10379622perdure
perjure16327962perjure
perjury19244252perjury
perter84422282perter_
perturbed1443352perturbed
perturber1343152perturber
apertural1144093apertural
apertured1244063apertured
apertures1146473apertures
century1237193century
denture8311893denture
disturb1046233disturb
exurb1457703_e_xurb
feature1039853feature
gesture839243gesture
lecture9149523lecture
mercury14364893mercury
nervure1034973nervure
nurture736643nurture
overture111511683overture
overturn11157303overturn
parura8310583par_ura
parure8312523par_ure
pasture9311463pasture
pearter9412743pearter_
pelter83321623pelter_
pelters93720313pelters
peltry11288653pelt_ry
penury1148103pe_nury
percuss1137163percuss
perdu84216273perdu__
perdue93912633perdu_e
perdues103511333perdues
perdured12287403perdured
perdures11289683perdures
perdus93711273perdu_s
perform1439283perform
perfume1446503perfume
perfumy1763933perfumy
perfuse1247663perfuse
peritus9311803peritu_s
perjured18286273perjured
perjurer17285903perjurer
perjures17268083perjures
permute1138793permute
perry105222713per__ry
pert66759323pert___
pertain92714963pertain
pertest9317043pertest
pertly115312553pert_ly
perturbers1442633perturbers
perturbing1543563perturbing
peruke123210393per_uke
peruse84016843per_use
pervert12315583pervert
pester84827593pester_
pesters93827093pesters
petard95013803pe_tard
peter74427593pe_ter_
peters86624593pe_ters
petter83924773petter_
petters93722363petters
pewter114013673pewter_
pewters124113353pewters
picture1158613picture
porter84224413porter_
porters93722703porters
posture9313253posture
precure11312553precure
prereturn1143393prereturn
preterm11310163preterm
pretor8315753pretor_
pretors9316813pretors
preverb14317063preverb
purpura1144793purpura
purpure1195993purpure
return623222523re_turn
texture1497083texture
torture738593torture
venture10311173venture
venturi1037203venturi
verdure11287773verdure
vertu85017613vertu__
vertus94613603vertu_s
vesture10310373vesture

Search took 7 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.406440125.6
2DLD Change Limit134027886.36021073.4
3Display Results88880.0302933.3
 (SQL Overall)178691886.79626293.6
 
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.