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

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

170 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
frame10582180(None) 
arame75026621arame
fame95639391f_ame
flame105124441flame
frae75330471fra_e
framed125116521framed
framer114817441framer
frames115119861frames
aflame1138722aflame
arames84622572arames
blame95625492blame
brace95629272brace
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
brome94421972brome
brume95817982brume
came87648752_came
crake114823522crake
cram85635492cram_
crambe1239072crambe
cramp115120692cramp
crams96229152crams
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
creme94319322creme
crime94822692crime
dame77140312_dame
drake104918302drake
dram75832002dram_
drama85117422drama
drams86025832drams
drape85319632drape
drave95219272drave
enframe1247362enframe
erase54925492erase
face96140122f_ace
fade85736352f_ade
fake115534942f_ake
famed115928342f_amed
fames105735922f_ames
fane75343572f_ane
farce104925322farce
fare76354462f_are
farle86929242farle
farm95934532farm_
farmed125117652farmed
farmer115017372farmer
farms106324952farms
fate75444282f_ate
fave105532962f_ave
faze165630042f_aze
fease84824872fease
feaze175216312feaze
feme96130542f_eme
femme125011432femme
flake125119972flake
flam96333292flam_
flambe13489152flambe
flamed124618972flamed
flamen115215992flamen
flamer114919122flamer
flames114723692flames
flams105125012flams
flamy135217472flamy
flare84823632flare
flume106021172flume
foam97127172foam_
foamed126014402foamed
foamer114714312foamer
foams105017952foams
foamy135313202foamy
forage104617002forage
foram105124932foram_
foramen12310532foramen
forams115115912forams
forme105225992forme
frag85126272fra_g
frags96322172frags
frail85220212frail
fraise94214912fraise
framers125113822framers
franc104615412franc
frank124417512frank
frap95925812fra_p
frappe13286952frappe
fraps105620552fraps
frass85321122frass
frat75648542fra_t
frater94520592frater
frats86829672frats
fraud939862fraud
fray105428902fra_y
frayed135012162frayed
frays116920102frays
free75940182fr_ee
fremd115010322fremd
frere85617722frere
frise85322452frise
froe75329992fr_oe
from96923922from_
frore86218802frore
froze174515652froze
frump126912562frump
fume96727632f_ume
furane94015492furane
game76644322_game
grace85124542grace
grade75126092grade
gram77034582gram_
grama85620282grama
gramme114210332gramme
gramp106218322gramp
grams85327312grams
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
grime85021322grime
grume86218162grume
hame97043132_hame
irade65618152irade
irate55627982irate
kame105728242_kame
lame66849292_lame
name65637412_name
orate55133302orate
pram85733492pram_
prams96125512prams
prase76128752prase
prate75135982prate
prime96525602prime
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
ram56867272_ram_
ramee74633852_ramee
ramen75625192_ramen
ramet75743142_ramet
rami66034092_rami
ramie75027822_ramie
ramp85934002_ramp
rams65950772_rams
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
reframe1239392reframe
rime65138892_rime
same65245642_same
shame105726702shame
tame66343662_tame
trace75829612trace
trade65026042trade
tram67034552tram_
tramel84113712tramel
tramp96319772tramp
trams75327672trams
trave85223032trave
urare56322552urare
urase54624692urase
urate55432162urate
wame95035482_wame

Search took 3 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.310576422.6
2DLD Change Limit538001702.28323565.5
3Display Results1701700.0463695.7
 (SQL Overall)1786911702.63967711.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.