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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
wrong9471232(None) 
prong85218111prong
wrang94716111wrang
wring95920711wring
wrongs10338931wrongs
wrung9549801wrung
along65419492along
among85813302among
barong96015822barong
bong75633412_bong
bring85528502bring
bronc91714342bronc
brung84613912brung
crone75231332crone
crony105918672crony
dong66031652_dong
drone65324982drone
drongo836792drongo
flong95815682flong
frog85624362fro_g
frond95316342frond
frons86124042frons
front85029222front
gong66827192_gong
grog65923342gro_g
hong85833952_hong
iring66025422iring
iron46728462iron_
irone55126362irone
irons55324132irons
irony85015902irony
klong105310402klong
krona93611792krona
krone94018732krone
long56933342_long
orang65119942orang
pong76231142_pong
prang84820322prang
prog75729002pro_g
prone75332622prone
prongs94314482prongs
rang56939162_rang
ring56541152_ring
rung56429972_rung
sarong73914872sarong
song55133672_song
strong74914882strong
thong95014182thong
throng10539972throng
tong56434352_tong
trog57628212tro_g
trona54118952trona
trone55131862trone
waring105029442waring
whang124813382whang
wing86339222w_ing
wiring104521022wiring
wog76242732w_o_g
won66252062w_on_
wonk116125302w_onk
wons74942042w_ons
wont75842502w_ont
wooing104214662wooing
worn75631752worn_
wrangs104611912wrangs
wren78221682wren_
wrens85016242wrens
wrings104012972wrings
wronged12397672wronged
wronger11288822wronger
wrongly1434552wrongly
wrote84717482wrote
wroth116815882wroth
wrying13379622wrying

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800741.48336277.8
3Display Results74740.0164625.0
 (SQL Overall)178691741.81298615.3
 
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.