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 “surfeit” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 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
surfeit1031034(None) 
surfeits1146221surfeits
forfeit1339202forfeit
surest65026762sur_est
surfed103814462surfe_d
surfeited1344592surfeited
surfeiter1244712surfeiter
surfer93515882surfe_r
surfers103614132surfers
surfier102613542surfier
surfiest112414432surfiest
surveil1045092surveil
aurei54821863aur_ei_
barefit1249723barefit
buffest15298643buffest
buffet143113783buffe_t
buret77444013bur_e_t
burnet84326173burne_t
curet75447643cur_e_t
curfew14426743curfe_w
curfews15294913curfews
current9313693current
curtest9713963curtest
curvet114720243curve_t
esurient849293esurient
forfeits1445803forfeits
funfest13348083funfest
gurnet74920873gurne_t
murein8311763mur_ein
murkest133110203murkest
outfelt10310603outfelt
outfit93014953outf_it
parfait12312053parfait
perfect141010833perfect
purest84021933pur_est
pursuit948273pursuit
refit84230063__refit
safest95016603s_afest
sarment9318763sarment
scurfier13267053scurfier
scurfiest14236863scurfiest
serein63318463ser_ein
serest64831613ser_est
serpent92916283serpent
slugfest1244923slugfest
sobeit8315363s_obeit
soffit1237883s_offit
sorbent92915243sorbent
sorbet83924083sorbe_t
sorest65028003sor_est
sourest7515713sour_est
sprent84522383spr_ent
spriest92718643spriest
sprit76736403spr__it
spryest12247813spryest
strait64025893str_ait
street64125773str_eet
suavest10310623suavest
subedit1049403subedit
subfix1835073subf_ix
subject18258633subject
sublet82827243suble_t
submit10312673su_bmit
subnet82520933subne_t
subrent9315083subrent
subsect112611843subsect
subset83122583subse_t
subtest9513963subtest
subtext1647653subtext
subunit948953subunit
subvert12312893subvert
suet46754823su__e_t
suffer124314513suffe_r
suffers133113543suffers
suffix1935233su_ffix
suggest9310863suggest
suit45649873su___it
sulfid1039063sulf_id
sulfite10310473sulf_ite
summit10311543su_mmit
sunbelt939233sunbelt
sunfast1038503sunfast
sunket103721363sunke_t
sunlit61516103su_nlit
sunset63723633sunse_t
sunsuit748693sunsuit
surcoat9412923surcoat
sure45447413sur_e__
surefire1145203surefire
surely93816463sur_ely
surer54833093sur_e_r
surety93515013sur_ety
surf76039313surf___
surface1238653surface
surfbird1442593surfbird
surfboat1345333surfboat
surfeiters1343633surfeiters
surfeiting1445023surfeiting
surffish1744783surffish
surfing112914483surfing
surflike1535933surflike
surfman1236203surfman
surfmen1235993surfmen
surfs85022543surf__s
surfside1244853surfside
surfy115319473surf__y
surge65027693surge__
surged84118883surge_d
surgeon837003surgeon
surger74320093surge_r
surgers83517483surgers
surgery11319213surgery
surges73924593surge_s
surimi839103surimi_
surimis938843surimis
surlier72915443surlier
surliest82416913surliest
surprint1049533surprint
surreal739233surreal
surrey94414583surre_y
surreys10489443surreys
surtout7411673surtout
surveils1144523surveils
survey124111673surve_y
surveys13357573surveys
suspect1158513suspect
tuffet122612083tuffe_t
turbit8715113tur_bit
turfed103110963turfe_d
turfier10249793turfier
turfiest112410133turfiest
turgent8712393turgent
turret63121853turre_t
unfelt92413463_unfelt
unfit84518563_unf_it
uraei53016083_uraei_
ureic74514463_ur_eic
urgent73816043_urgent
urtext1337433_urtext

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.1561145455.1
2DLD Change Limit1340271397.12318816.1
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.32524394.7
 
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.