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

146 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
outpity123749(None) 
outcity1238451outcity
outfit93014952outfit_
outfits102210832outfits
outhit92818472outhit_
outhits102213502outhits
outpitch1543282outpitch
outplay12267722outplay
outpray12268082outpray
output8712852output_
outputs988492outputs
outsit63620892outsit_
outsits73215252outsits
outwit93014592outwit_
outwith13279132outwith
outwits103110862outwits
uppity1335102_uppity
bumpily1665653bumpily
butty104020113but__ty
cutty105417223cut__ty
duality1147963duality
dumpily1566233dumpily
entity9312053ent_ity
fatuity1336043fatuity
fortuity1465573fortuity
furmity1535183furmity
futility1446973futility
futurity1454883futurity
goutily1137933gout_ily
gutsily11267223gutsily
gutty94516993gut__ty
jumpily2174983jumpily
jutty154914643jut__ty
lumpily1476563lumpily
mouthily1645903mouthily
mutiny113612683mut_iny
nudity1037993nu_dity
nullity1037363nullity
nutpick1543883nutpick
nuttily10308633nuttily
nutty84816873nut__ty
obesity1275653obesity
obtusity1343683obtusity
oddity1135243o_ddity
opacity1436313opacity
orality101111683orality
outact8317203outact_
outacts9310213outacts
outate62923403out_ate
outbid91411863outbi_d
outbids1098913outbids
outbitch1543443outbitch
outbuy1146943out_buy
outby10411533out__by
outcry1137993out_cry
outdate83016423outdate
outdid81210923outdi_d
outeat62824533outeat_
outeats72215703outeats
outfind1139563outfind
outfire1049713outfire
outfish132210573outfish
outfly1238273out_fly
outgive11199253outgive
outing74128153out_ing
outjinx2135823outjinx
outjut13610073outjut_
outjuts1476493outjuts
outkick1235573outkick
outkill1136553outkill
outkiss1137783outkiss
outlay92711793out_lay
outlet63728683outlet_
outlets73616363outlets
outlie62419533outli_e
outlier72216143outlier
outlies72421993outlies
outline72321333outline
outlive102513033outlive
outpace112613023outpace
outpaint10311773outpaint
outpaints1145283outpaints
outpass939713outpass
outpitied1245903outpitied
outpities1148623outpities
outpitying1644773outpitying
outplan9249443outplan
outplays13246843outplays
outplod10106343outplod
outplot9109483outplot
outplots1086363outplots
outpoint10311513outpoint
outpoints1145703outpoints
outpoll946793outpoll
outport9714123outport
outports1048273outports
outpost9612443outpost
outposts1037253outposts
outpour937423outpour
outprays13236933outprays
outprice1238273outprice
outpull956443outpull
outpush1245493outpush
outrate72323183outrate
outride82615683outride
outrig72812853outri_g
outrigs82811263outrigs
outring84021023outring
outsat62920283outsat_
outsay92611873out_say
outset64027453outset_
outsets73514923outsets
outside82414193outside
outsin63617563outsi_n
outsing83320463outsing
outsins73417863outsins
outsize162411753outsize
outstay1047683outstay
outvie92412803outvi_e
outvied11239693outvied
outvies102214243outvies
outvote1038803outvote
outwait10411763outwait_
outwaits1137493outwaits
outwile10310263outwile
outwill1037323outwill
outwind1139153outwind
outwish13289853outwish
outwrit10411423outwrit_
outwrite1139453outwrite
ovality1377593ovality
pity96031933___pity
pulpily1436103pulpily
pulpit10310933pulpit_
pulpits1137243pulpits
purity114114913pu_rity
putty104721403put__ty
quality1938563quality
roupily1246653rou_pily
ruttily10338613ruttily
rutty85617803rut__ty
suavity1336313suavity
tutty85217023tut__ty
unity84918493_u_nity
utility1038703_utility
yuppify2042163yuppify

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.406440125.6
2DLD Change Limit1340271467.58017681.7
3Display Results1461460.1101327.3
 (SQL Overall)1786911468.09622071.5
 
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.