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

470 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
reports9491621(None) 
deports105012881deports
report85326011report_
repots85621001repo_ts
resorts74817191resorts
retorts76016511retorts
dehorts11379772dehorts
departs104310682departs
deport94922392deport_
depots94716342depo_ts
exports1647982exports
imports11309622imports
jetports1743532jetports
ports75934592__ports
presorts105311672presorts
rapports1245962rapports
reboots93512092reboots
rebores95319162rebores
recoats92616642recoats
records105213922records
recorks134813022recorks
redouts81411652redouts
reexports1843242reexports
reforms1239812reforms
reimports1343662reimports
remoras9314072remoras
reparks13249512reparks
repasts93611932repasts
repeats94316052repeats
repents93717622repents
reperks13298092reperks
replots93412632replots
repolls939052repolls
reported11312702reported
reporter10411422reporter
reporters1139172reporters
repos74725792repo__s
reposes94021262reposes
reposits10310452reposits
repot75132622repo_t_
repours9310222repours
repros84216002rep_ros
resorbs95010522resorbs
resort65728612resort_
respots92912762respo_ts
retort66831142retort_
reverts104715042reverts
revolts1038892revolts
rewords115413972rewords
reworks145113592reworks
riposts9279402riposts
seaports1038462seaports
sports84619182_sports
aborts84916183_aborts
airports1046463airports
aport75432173_aport_
assorts73310153assorts
bedposts1343873bedposts
besots86415453beso_ts
bevors111610343bevor_s
beworms1437913beworms
borts76735453__borts
carports1238943carports
cavorts1237933cavorts
ceorls848163ce_orls
cohorts123411103cohorts
comports143411983comports
copouts11311073copouts
crepons1139313crepo_ns
decocts1237833decocts
decors94017773decor_s
deforms1337803deforms
dehorns11428363dehorns
dehort104618103dehort_
depart94720563depart_
deperms1236603deperms
depicts12358463depicts
deplores1139533deplores
depones103717093depones
deported1249703deported
deportee11510353deportee
deportees1256643deportees
deporter1169393deporter
deporters1277793deporters
deposes103117213deposes
deposits1138843deposits
depot85727923depo_t_
deserts82513053deserts
desorbs10437713desorbs
despots10319683despo_ts
deworms1338013deworms
disports111111113disports
dropouts1144993dropouts
dropworts1543843dropworts
eelpouts1044323eelpouts
efforts1334703efforts
epacts105010393_epacts
ephors11311403_ephor_s
epochs1335813_epochs
epodes94315563_epodes
epos66723733_epo__s
eposes84418783_eposes
ergots74512373ergo_ts
errors63311313error_s
escorts9418403escorts
everts94514893_everts
exerts133712293_exerts
exhorts1746313exhorts
experts1659063experts
export15412183export_
extorts1447753extorts
fedoras1137923fedoras
felworts1445953felworts
fetors91014473fetor_s
firepots1346893firepo_ts
foreparts1445223foreparts
forts86034453__forts
gemots93712153gemo_ts
gosports1185903gosports
hearts96218943he_arts
heliports14104223heliports
helots95217703helo_ts
hepcats1436473hepcats
homeports16115553homeports
imparts11298533imparts
import102713753import_
imposts11269003imposts
intorts7310963intorts
jetport1646643jetport_
lakeports1543383lakeports
lepers84817323leper_s
leporid1048153leporid
leporids1145673leporids
leprous938843leprous
misreports1443943misreports
morts75533563__morts
nerts55924983ne__rts
orts46538333___orts
outports1048273outports
parts77743373__parts
pelorus939273pelorus
pepos96620083pepo__s
pieforts1344863pieforts
poets76024443__poets
pores75849033__pores
porks115124143__porks
porns75527343__porns
port66059633__port_
posts75228783__posts
pots66452363__po_ts
pouts75530323__pouts
preforms1537393preforms
prepares122014163prepares
presort95219533presort_
pretors9316803pretor_s
preworks17599003preworks
purports1265783purports
ragouts838533ragouts
ragworts12125803ragworts
ramparts1245583ramparts
rapers84327183raper_s
rapists92510743rapists
rapport11311223rapport_
raptors94213353raptor_s
razors154711653razor_s
reacts83616603re_acts
readopts1146483readopts
readorns938273readorns
readouts938883readouts
reapers93520453reaper_s
rearms85114653re_arms
rears54739653re_ar_s
reassorts945623reassorts
rebaits9312573rebaits
rebars84019823rebar_s
rebirth1244933rebirth
rebirths1343083rebirths
reboards1138773reboards
reboils94111713reboils
rebooks134010513rebooks
reboot84119333reboot_
rebops10311423rebo_ps
rebore86625643rebor_e
rebored105015883rebored
reborn810016953rebor_n
rebozos1835143rebozos
rebuts84015193re_buts
recants93217093recants
recasts93413533recasts
recepts113010263recepts
recharts1337663recharts
recits83621353re_cits
recoals94214623recoals
recoat84024273recoat_
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recons84922993reco_ns
recooks134711233recooks
record96117423recor_d
recork126315483recor_k
recounts1038773recounts
recoups1188843recoups
recross989833recross
rectors93520513rector_s
recurs83315803recur_s
recuts83817373re_cuts
redacts10510943redacts
redcoats1147123redcoats
redocks14409933redocks
redoes74623753redo_es
redons75222183redo_ns
redos65126763redo__s
redoubts11153973redoubts
redout71820253redout_
redowas1138393redowas
redoxes15310883redoxes
redpolls1144013redpolls
redroots937753redroots
reearns749103reearns
reedits8511743reedits
reemits9611303reemits
reests64618893re_ests
reexport1745633reexport_
refects124012743refects
refers93921083refer_s
refires104820313refires
refits94017653re_fits
reflets103513153reflets
refloats1156913refloats
refocus1236973refocus
refolds11298953refolds
reforest1139963reforest
reforests1245533reforests
reforge11259033reforge
reforges12249333reforges
reform11312703refor_m
reformats1445713reformats
refronts1137773refronts
regards94112563regards
regents83416543regents
reglets83512983reglets
regorge9257833regorge
regorges10238413regorges
regrets83212923regrets
regrows11269153regrows
reheats104513523reheats
rehires105016113rehires
reimport1246503reimport_
rejects163910693rejects
rejoins143111383rejoins
reknits1137073reknits
reknots1136783reknots
relents74018503relents
relets64025673re_lets
relicts94414593relicts
relists73817053relists
reloads8911313reloads
reloans7313133reloans
relocks134411293relocks
relooks114010723relooks
relucts9369673relucts
remarks13329983remarks
remeets93712413remeets
remelts93511493remelts
remints95117293remints
remits85622943re_mits
remolds10299703remolds
remora8414583remor_a
remorid10311863remorid
remorse9311713remorse
remorses10311993remorses
remote84222603remo_te
remotes94521613remotes
remounts1036373remounts
removes124514713removes
renests74014213renests
rennets75212633rennets
renowns10277833renowns
rents55935183re__nts
reoils64516873re_oils
reopens939373reopens
repacks15269543repacks
repaints1038483repaints
repairs9319973repairs
repark123511713repar_k
repartee10312753repartee
repartees1147253repartees
repass84114703rep_ass
repast83520633repast_
repaves123513653repaves
repays113813973rep_ays
repeals94014523repeals
repeat85127213repeat_
repegs93311943rep_egs
repels84318763rep_els
repent84728873repent_
reperk122511773reper_k
rephrase1346733rephrase
repines94927383repines
repins84924313rep_ins
replans92814943replans
replants102811243replants
replate93420053replate
replates102919263replates
replays12399763replays
replete92912983replete
repletes102812463repletes
replies94521043replies
replot83818593replot_
replows12329703replows
repo66027543repo___
repolish1347933repolish
repoll8410793repo_ll
reportage1245023reportage
reportages1344383reportages
reporting12513903reporting
reposal939113reposal
reposals1037403reposals
repose84121413repo_se
reposed103616273reposed
reposer93715333reposer
reposers102911603reposers
reposit9315863reposit
repotted1139283repotted
repour8310993repo_ur
repoured1139563repoured
repousse1046053repousse
repower12329883repower
repowers13288533repowers
repps95114343rep__ps
repress92712683repress
reprints1039903reprints
reprise92715043rep_rise
repro75315913rep_r_o
reprobe112310133reprobe
reprobes121910293reprobes
reproof1238783reproof
reproofs1346063reproofs
reprove122911073reprove
reproves132011473reproves
reps65937953rep___s
repugns1035393repugns
repumps1334403repumps
repute84716093rep_ute
reputes94615963reputes
rerents73319423rerents
rerolls739943rerolls
reroofs1037943reroofs
reroute7313963reroute
reroutes8312223reroutes
rescores105415693rescores
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613re_sets
reshoots11228413reshoots
resifts10378703resifts
resists74414923resists
resits64725563re_sits
resoaks1148973resoaks
resods74116303reso_ds
resojets1535343resojets
resoles73823653resoles
resorb84914343resor_b
resorted9313493resorted
resorter8312173resorter
resorters939683resorters
resows93915353reso_ws
respects1247703respects
respires10311903respires
resplits1037723resplits
responds1136913responds
respools1036243respools
respot83117633respo_t_
resprouts1174823resprouts
restarts8310873restarts
restores85222983restores
rests54935873re__sts
results739833results
retards85015003retards
retests73813853retests
retints74717013retints
retires74726213retires
retools73411023retools
retore67630763retor_e
retorn610923423retor_n
retorted9312333retorted
retorter8410733retorter
retorters938773retorters
retros63820193re_tros
rets45352563re___ts
returns79712593returns
reverbs12368863reverbs
reveres103621343reveres
revers94529633rever_s
revert93529113revert_
revests104413733revests
revets94022173re_vets
revokes144212503revokes
revolt9316223revolt_
revote94917453revo_te
revotes104716393revotes
rewards114813993rewards
rewarms12439593rewarms
rewets94617213re_wets
rewires104717113rewires
reword106321403rewor_d
rewore938030153rewor_e
rework136619783rewor_k
reworn98122193rewor_n
rewrote1039113rewrote
rezeros1647453rezeros
rezones163213943rezones
rhetors1038513rhetor_s
ribworts1345093ribworts
rigors72813713rigor_s
riots54922013r_io_ts
ripcords1344073ripcords
ripoffs1543383ripoffs
ripost83615003ripost_
riposte9269623riposte
ripostes10239083ripostes
robots8313143robo_ts
roosts64916323r_oosts
roots55933673r__oots
ropers84325903roper_s
rotors64917933rotor_s
rots46454093r__o_ts
routs57133413r__outs
rubouts937973rubouts
rumors81110393rumor_s
runouts737343runouts
ryots85313783r_yo_ts
sapors84118813sapor_s
seaport9315593seaport_
senoras72714953senoras
senores73218113senores
senors63620783senor_s
sepoys1138473sepo_ys
septets998953septets
septs75420603sep__ts
setouts74110333setouts
sexpots1636293sexpo_ts
shorts95321733_shorts
skorts104211293_skorts
snorts64116493_snorts
sopors85215193sopor_s
sorts54536663__sorts
spirts85317133_spirts
spores84726613_spores
sport75935983_sport_
sporty115112493_sporty
spots74424103_spo_ts
spouts85115113_spouts
spurts84814973_spurts
supports1246513supports
teapots939053teapo_ts
teleports1145433teleports
tenors63217753tenor_s
tephras1236283tephras
tepoys1137543tepo_ys
torts56138123__torts
tremors93711213tremor_s
vapors113812693vapor_s
verts85724733ve__rts
whorts125111433_whorts
worts88631183__worts

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.1701051123.5
2DLD Change Limit1340274707.83017117.1
3Display Results4704700.1702764.7
 (SQL Overall)1786914708.17021871.6
 
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.