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

131 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
outpray1226808(None) 
outplay12267721outplay
outprays13236931outprays
outbrag1036992outbrag
outcry1137992outcr_y
outdrag937002outdrag
outdraw1136902outdraw
outlay92711792out_lay
outpity1237492outpity
outplan9249442outplan
outplays13246842outplays
outprayed1545752outprayed
outran63218892out_ran
outsay92611872out_say
outstay1047682outstay
astray95615543ast_ray
autarky1444703autarky
betray111511443bet_ray
butyral1245713butyral
cutaway1544433cutaway
estray95713333est_ray
futural1037283futural
gunplay1343233gunplay
hurray12459913hu_rray
kouprey1652793kou_prey
orfray1234393o_rfray
osprey1134883o_sprey
ostiary1036463ostiary
outbark1339453outbark
outbeam1137973outbeam
outbrags1136693outbrags
outbrave1357133outbrave
outbrawl1344823outbrawl
outbreak1444773outbreak
outbred10311263outbred
outbuy1146943out_buy
outby10411533out__by
outcity1238453outcity
outcrawl1344583outcrawl
outcrop1146773outcrop
outcrow1246343outcrow
outdare83113403outdare
outdrags1046583outdrags
outdrank1345433outdrank
outdrawn1245013outdrawn
outdraws1236233outdraws
outdream1144713outdream
outdrew1137143outdrew
outdrop1036193outdrop
outearn7310683outearn
outeat62824533out_eat
outer55633303outer__
outers64230173outer_s
outfly1238273out_fly
outgas7313203out_gas
outgnaw11124353outgnaw
outgrew1136713outgrew
outgrin8810553outgrin
outgrow1136323outgrow
outhear10910603outhear
outlaw9279643out_law
outlays102610903out_lays
outlead83311103outlead
outleap9298293outleap
outman83115033out_man
outpace112613023outpace
outpass939713outpass
outplace1257913outplace
outplans10259533outplans
outplayed1545213outplayed
outplod10106343outplod
outplot9109483outplot
outpoll946793outpoll
outport9714123outport
outports1048273outports
outpost9612443outpost
outpour937423outpour
outpraying1646523outpraying
outpreach1642703outpreach
outpreen1046913outpreen
outpress10118183outpress
outprice1238273outprice
outpull956443outpull
outpush1245493outpush
output8712853outp_ut
outputs988493outputs
outrace92418553out_race
outrage82616893out_rage
outrang83813953out_rang
outrank112611973out_rank
outrate72323183out_rate
outrave102614413out_rave
outre53922203out_r_e
outread82811093outread
outrig72812853out_rig
outroar739513outroar
outrow9311183out_row
outrun63213303out_run
outsat62920283out_sat
outsaw92610283out_saw
outsays102710403out_says
outsoar739493outsoar
outspan938743outspan
outspeak1454583outspeak
outsprang1243903outsprang
outspread1243503outspread
outstays1156623outstays
outswam1246613outswam
outtrade938343outtrade
outtrot7312613outtrot
outwar91011513out_war
outward11811403outward
outwars10912793outwars
outwear1097713outwear
outweary1485393outweary
outwrit10411423outwrit
overpay15228263overpay
portray1237483port_ray
pray96331533___pray
respray1236503respray
routeway1443413routeway
spray106720063__spray
stray88525573_st_ray
sunray9310123su_nray
supra73614253su_pra_
sutra54217933sut_ra_
sutras64818593sut_ras
sutural7310223sutural
tray77632593__t_ray
vouvray1641933vou_vray
whipray1843403whipray

Search took 8 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.423422437.4
2DLD Change Limit1340271316.93619323.4
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.40524131.1
 
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.