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

109 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
outpolls104621(None) 
outpoll946791outpoll_
outpulls1065441outpulls
outrolls847821outrolls
outcalls1038742outcalls
outfalls1138142outfalls
outfools1136532outfools
outhowls1445712outhowls
outkills1245142outkills
outplods11105612outplods
outplots1086362outplots
outpolled1246172outpolled
outports1048272outports
outposts1037252outposts
outpours1036652outpours
outpull956442outpull_
outroll749302outroll_
outsells888642outsells
outsoles8813112outsoles
outspells11104602outspells
outtells896852outtells
outwills1135652outwills
outyells11105302outyells
atolls65511353_at_olls
cupolas11277753cu_polas
extolls1444603ext_olls
nutgalls943953nutgalls
ostioles839273ostioles
outbawls1336053outbawls
outboxes1737823outboxes
outbulks1444763outbulks
outbully1345103outbully
outcall9310123outcall_
outcomes1239753outcomes
outcooks1436713outcooks
outdoers937503outdoers
outdoes8313113outdo_es
outdoors936423outdoors
outduels945053outduels
outfall1039683outfall_
outfeels1135063outfeels
outflows1445463outflows
outfool1037333outfool_
outfoots1136883outfoots
outfoxes1836743outfoxes
outglows1244933outglows
outgoes8312643outgo_es
outhauls1137203outhauls
outhowl1337203outhowl_
outkill1136553outkill_
outlooks1236793outlooks
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outpaces122411943outpaces
outpass939713outp_ass
outpeople1343153outpeople
outpeoples1443133outpeoples
outplan9249443outp_lan
outplans10259533outplans
outplay12267723outp_lay
outplays13246843outplays
outplod10106343outp_lod
outplot9109483outp_lot
outpoint10311513outpoint
outpoints1145703outpoints
outpolling1346213outpolling
outport9714123outpo_rt
outpost9612443outpo_st
outpour937413outpo_ur
outpower1336673outpower
outpowers1445193outpowers
outprays13236933outprays
outpress10118173outpress
outpulled1245253outpulled
outpupils1342283outpupils
outputs988493outp_uts
outroars838903outroars
outrocks1437903outrocks
outrolled1037433outrolled
outroots839873outroots
outrows10311403outro_ws
outsails8139863outsails
outscolds12113653outscolds
outsell7109263outsell_
outsmells1194103outsmells
outsoars838833outsoars
outsold8109073outso_ld
outsole71013433outso_le
outspell10125453outspell_
outsulks1244993outsulks
outtalks1236503outtalks
outtell797883outtell_
outtold8107603outto_ld
outvotes1137903outvotes
outwalks1535993outwalks
outwiles1139233outwiles
outwill1037323outwill_
outworks15148973outworks
outyell1095843outyell_
outyelps1393073outyelps
polls74627723___polls
quolls15327303qu__olls
redpolls1144013redpolls
repolls939053_repolls
strolls739183_strolls
tolls54728433__t_olls
trolls64613943__trolls
unrolls797793_unrolls

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 Filter1786911461620.186960704.3
2DLD Change Limit1461621097.97018339.0
3Display Results1091090.0333303.0
 (SQL Overall)1786911098.18921820.9
 
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.