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

207 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
puler7482662(None) 
paler75436931paler
poler74431791poler
pule65040951pule_
puled84926521puled
pulers83820281pulers
pules74538811pules
puller83820811puller
pulper103513271pulper
pulser84215191pulser
purer75127901purer
ruler54923341ruler
abler75624312abler
auger64922472auger
aulder7511452aulder
baler75635272baler
bluer74918492bluer
bugler94717722bugler
bulger94917352bulger
burler84723832burler
butler84220032butler
buyer105013092buyer
cuber95222532cuber
culet76040342culet
culex144613932culex
culler84322252culler
culver113010632culver
curer75030752curer
curler85221322curler
cuter74728222cuter
cutler84718032cutler
dueler74213682dueler
duller74017702duller
duper85519002duper
filer85433002filer
fouler93614902fouler
fueler94313932fueler
fuller94220382fuller
fumer105918232fumer
furler93616402furler
gluer65116772gluer
gular6314832gular
gules64831042gules
gulper93410212gulper
haler85033522haler
hauler95015122hauler
huger94914872huger
huller93919102huller
hurler94717222hurler
idler65015662idler
iller54821292iller
julep14310532julep
luger65322082luger
luller63415482luller
lurer54625312lurer
mauler84416712mauler
miler75733062miler
mule65236972mule_
muled85824432muled
mules75034292mules
muley104819282muley
muller83820352muller
muser76024122muser
muter74525542muter
nuder66416832nuder
ogler65917442ogler
oiler54628282oiler
outer55633302outer
pacer96131612pacer
pager84728202pager
pale66055012pale_
palea75028662palea
paled85538722paled
pales75753802pales
palet74650802palet
palier85023562palier
palmer105816542palmer
palter84423262palter
paper95128662paper
parer75839902parer
pater74740722pater
pauper103511942pauper
pauser84415962pauser
paver104225832paver
pawer104422972pawer
payer105125722payer
pedler93614612pedler
peeler83517382peeler
peer66238352p_eer
pele65539552pele_
peles75738082peles
pelter83321622pelter
per56353092p__er
peter74427592peter
pier66035292p_ier
piker115622842piker
pilar75221502pilar
pile65649692pile_
pilea75123952pilea
piled85232992piled
pilei74021782pilei
piles74742612piles
pilfer1139162pilfer
piper96523192piper
plea66830602p_lea
pleb86123812p_leb
pled75231432p_led
plew97222812p_lew
plex137321372p_lex
plier75221282plier
plyer106214332plyer
poker115122882poker
polar75623452polar
polder94019252polder
pole65951302pole_
poled84934842poled
polers84225642polers
poles75351002poles
poller83921852poller
pooler83819842pooler
poser75128772poser
poulter93712012poulter
pourer84516042pourer
pouter83923982pouter
power105325952power
prier75027762prier
pruner83413452pruner
pryer104415312pryer
pubes94423402pubes
puce85127882puce_
puces94924632puces
pucker143817632pucker
puddler112910752puddler
puffer144610732puffer
puke105025462puke_
puked124716222puked
pukes114523022pukes
pul56138062pul__
pula65129372pul_a
puli65527622pul_i
pulik113613302pulik
pulis74225602pulis
pull64731662pul_l
pulled94322192pulled
pullers93618482pullers
pullet84026332pullet
pulley113713402pulley
pulls74425052pulls
pulp84825352pul_p
pulped114612532pulped
pulpers114612282pulpers
pulpier1148622pulpier
pulps95116482pulps
pulpy124612362pulpy
puls65437562pul_s
pulsar8329362pulsar
pulse74219972pulse
pulsed94013722pulsed
pulsers94213152pulsers
pulses83818662pulses
pumper124415552pumper
punier84519222punier
punker123718822punker
punner84918152punner
punter84320022punter
pur56840552pu__r
pure65543332pure_
puree74632842puree
purfler12248732purfler
purger94717232purger
purled94520742purled
purpler11289262purpler
purr64925812pu_rr
purser85020472purser
puses75532202puses
pusher114318282pusher
pusley11379612pusley
putter83921442putter
puzzler17276962puzzler
queer143712812queer
ruder65320542ruder
ruer46127562ru_er
rule49938422rule_
ruled65822522ruled
rulers64317092rulers
rules55234252rules
rulier65016352rulier
suber74924502suber
suer45334032su_er
sulker104015922sulker
super74924482super
surer54833092surer
sutler63718392sutler
taler56034862taler
tiler56131022tiler
tuber75420682tuber
tule45735872tule_
tules54532792tules
tuner56022682tuner
tuyer85414292tuyer
ulcer7310752_ulcer
upper93714262upper
user45023002_user
viler86324162viler
waler84229262waler
yule75725142yule_
yules84521582yules

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.0931921408.6
2DLD Change Limit538002071.70331591.3
3Display Results2072070.0633285.7
 (SQL Overall)1786912071.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.